SELECT `a`.*, `b`.`id` as `representative_id`, `b`.`name` as `representative_name`, `b`.`staff_id` as `representative_employment_id`
FROM `job__invoice` `a`
LEFT JOIN `user` `b` ON `b`.`id` = `a`.`repID`
WHERE `a`.`jobID` = '831'
AND `a`.`is_delete` = 0