SELECT *                                                  
FROM only_some_users
INNER JOIN some_other_users
  ON only_some_users.id = some_other_users.id;
