SELECT dept_name, ifnull(z_studen.cou, 0) AS '人数' FROM ( SELECT dept_id, COUNT(*) AS cou FROM z_studen GROUP BY dept_id ) z_studen RIGHT JOIN z_department ON z_department.id = z_studen.dept_id