SELECT `a`.*, `b`.`name` as `reviewer_name`, `c`.`name` as `submit_by_name`
FROM `job__draft` `a`
JOIN `user` `b` ON `b`.`id` = `a`.`reviewer_id`
JOIN `user` `c` ON `c`.`id` = `a`.`submitted_by`
WHERE `a`.`job_id` = '1297'
AND `a`.`is_delete` = 0