试一下: declare @parent varchar(100) set @parent = 'test' ;WITH cte_test AS ( SELECT id, childs = COUNT(id) FROM [F_Categories] WHERE parent = @parent group by id ) SELECT A.[id], A.[name], B.childs FROM [F_Categories] A, cte_test B WHERE parent = @parent AND A.[id] = B.id ORDER BY A.pai
declare @parent varchar(100)
set @parent = 'test'
;WITH cte_test AS
(
SELECT id, childs = COUNT(id) FROM [F_Categories] WHERE parent = @parent group by id
)
SELECT A.[id], A.[name], B.childs
FROM [F_Categories] A, cte_test B
WHERE parent = @parent AND A.[id] = B.id
ORDER BY A.pai