SELECT dept.name, COUNT( emp.id ) AS 员工数FROM dept LEFT JOIN emp ON (dept.id = emp.dept_id)GROUP BY dept.name
