<?php
include_once('config/config.php');

$table1 = `sys_job`;
$table2 = 'sys_department';

$sql = "select `j`.*,`d`.`name` as dname from `sys_job` as `j` left join `sys_department` as `d` on `j`.`depid` = `d`.`id`";

$data = [];

$res = mysqli_query($conn,$sql);

if(!$res){
    echo mysqli_error($conn);
}
$data = mysqli_fetch_all($res,MYSQLI_ASSOC);

pre($data);

?>