SELECT count(A.ID_Job) AS C,ฺB.ID, B.Id_Emp, B.Name
FROM info_import AS A,
(SELECT ID, Id_Emp, Name
FROM info_employee) AS B
WHERE
A.ID = B.ID
GROUP BY A.ID
$sql =" SELECT COUNT(tb_im.ID_Job) AS total_job, tb_emp.ID, tb_emp.Id_Emp, tb_emp.Name FROM info_import AS tb_im ";
$sql.=", (SELECT ID, Id_Emp, Name FROM info_employee) AS tb_emp ";
$sql.=" WHERE tb_im.ID = tb_emp.ID GROUP BY tb_emp.Name ASC ";