SELECT `a`.`user_ID`, `b`.`name`
FROM `user__role` `a`
LEFT JOIN `user__employment_detail` `b` ON `b`.`user_id` = `a`.`user_ID`
WHERE `a`.`is_delete` = 0
AND `a`.`role` = 'SUPERVISOR'
AND `b`.`department_id` = '1'