SELECT u.*, a.* FROM `users` AS `u`, `admin` AS `a` WHERE `u`.`id` = `a`.`user_id` GROUP BY `a`.`user_id`