Êý¾Ý¿â²Ù×÷´íÎó£¡<br/>select SortName,SortStyle,SortURL,sortID ,(select count (*) from NewsSort as a where a.ParentID=b.sortID) as subcount,SortFolder from NewsSort as b  where SortStatus and ParentID=0 order by SortOrder asc