SELECT `a`.*, `b`.`user_id`, `b`.`name`, `b`.`staff_id`
FROM `job__pic` `a`
LEFT JOIN `user__employment_detail` `b` ON `b`.`user_id` = `a`.`staff_id`
WHERE `a`.`job_id` = '4'
AND `a`.`is_delete` = 0