不用CTE实现树形结构查询:--建测试表IF OBJECT_ID('wx_test_dep') IS NOT NULLDROP TABLE wx_test_depGOCREATE TABLE wx_test_dep(depId INT PRIMARY KEY,pDepId INT,depName NVARCHAR(20))GO--插入测试数据INSERT INTO wx_test_