SELECT `b`.`id`, `a`.`name`, `a`.`staff_id`, `b`.`email`
FROM `user__employment_detail` `a`
LEFT JOIN `user` `b` ON `b`.`id` = `a`.`id`
WHERE `a`.`department_id` IN('9')
AND `a`.`is_delete` = 0
ORDER BY `a`.`name`