SELECT `a`.*, `b`.`position` as `position_name`, `c`.`name` as `department_name`, `d`.`name` as `branch_name`, `c`.`branch_id`
FROM `user__employment_detail` `a`
LEFT JOIN `company__position` `b` ON `b`.`id` = `a`.`position_id`
LEFT JOIN `company__department` `c` ON `a`.`department_id` = `c`.`id`
LEFT JOIN `company__branch` `d` ON `d`.`id` = `c`.`branch_id`
WHERE `a`.`id` = '78'