SQL 树形菜单查询,查询本身和所有下级项
WITH Temp AS
(
SELECT * FROM Sys_Organization WHERE OUGUID = @OUGUID AND OrgState = 1 AND IsAvailable = 1 AND IsDel = 0SELE