mysql 求所有部门的员工个数

SELECT d.*,(
		SELECT COUNT(*)
		FROM staff s
    WHERE s.department_id=d.id
) sums
FROM departments d;

　　这样就可以 了！！