with menu(Id,Name,ParentId,Level)

as

(

select Id,Name,ParentId,0 as Level from dbo.Category where ParentId is Null

Union All

Select A.Id,A.Name,A.ParentId,B.Level+1 from dbo.Category A inner join menu B

on A.ParentId=B.Id

)

select * from menu order by Id

with menu(Id,Name,ParentId,Level,px,px2)

as

(

select Id,Name,ParentId,0 as Level,Id px, cast(Id as nvarchar(4000)) px2  from dbo.Category where ParentId is Null

Union All

Select A.Id,A.Name,A.ParentId,B.Level+1 ,B.px,B.px2+ltrim(A.Id) from dbo.Category A inner join menu B

on A.ParentId=B.Id

)

select * from menu order by px,px2