SELECT u1.user_id FROM user_units u1 LEFT JOIN user_units u2 ON u2.user_id=u1.user_id LEFT JOIN user_units u3 ON u3.user_id=u1.user_id WHERE u1.unit_id='2' AND u2.unit_id='3' AND u3.unit_id='4'