select treename , (select count(*) from tbltree where treename like rtrim(a.treename)+'%')-1 as 子节点数 from tbltree a