where_in null and 1

This looks more of a mysql question. I don't think you can use NULL inside a WHERE IN clause.
Try 'WHERE Login = 1 OR Login IS NULL'

You could use $db->get_compiled_select() to see how CI has constructed the query and then try and make it work in phpmyadmin or whatever.