百科类 sin sql_sysquery False cid supersql 0 目录ID false false with SubCategory(CategoryId,CategoryName,ParentId) as ( select CategoryId,CategoryName,ParentId from PE_EN_Category where CategoryId = @cid union all select C.CategoryId,C.CategoryName,C.ParentId from PE_EN_Category C, SubCategory SC where C.ParentId = SC.categoryid ) select * from SubCategory , ]]>