摘要： 获得所有user以及相关personfn_User_GetAllUserPerson with userSectorCte(userid, sectorid) as ( select u.id, us.SectorId from [User] u inner join User_Sector us on us.UserId = u.id where u.Validity = 1 and u.Level = @UserLevel UNION ALL SELECT userid,s.Id FROM Sector s INNER JOIN userSectorCte us ON us.sector 阅读全文