SELECT d.*,(
SELECT COUNT(*)
FROM staff s
WHERE s.department_id=d.id
) sums
FROM departments d;
这样就可以 了!!
SELECT d.*,(
SELECT COUNT(*)
FROM staff s
WHERE s.department_id=d.id
) sums
FROM departments d;
这样就可以 了!!
转载于:https://www.cnblogs.com/cbywan/p/10889149.html