该校区下所有员工
select * from employee e
INNER JOIN employee_department ed on e.id =ed.EmployeeId
LEFT JOIN department d on d.Id= ed.DepartmentId
where e.IsDeleted=0#未删除
and e.State=1#在职
and FIND_IN_SET(‘355‘,d.Path)#校区id
GROUP BY e.id;
校区下部门
原文：http://www.cnblogs.com/dieyaxianju/p/7873591.html