代码
SELECT d.DepartmentId, COUNT(d.DepartmentId) as Acount
FROM OrgChart_Departments d
JOIN dbo.OrgChart_RoleInDepartments rd ON d.DepartmentId = rd.DepartmentId
WHERE d.Disable = 0
AND rd.RoleId = '80195321-d274-4d2c-9fce-85b9c1ced4f1' group by d.DepartmentId
FROM OrgChart_Departments d
JOIN dbo.OrgChart_RoleInDepartments rd ON d.DepartmentId = rd.DepartmentId
WHERE d.Disable = 0
AND rd.RoleId = '80195321-d274-4d2c-9fce-85b9c1ced4f1' group by d.DepartmentId