I think you need to add an "OR imageid IS NULL" so if there's no associated record in the second table, the user record will still be returned.