with cte as
(
select vcOrganID, vcParentID, vcOrganName, 0 as lvl from tbOrgan
where vcOrganID = 2
union all
select d.vcOrganID, d.vcParentID, d.vcOrganName, lvl+1
from cte c inner join tbOrgan d on c.vcOrganID = d.vcParentID
)
select * from cte
select
vcOrganID, vcParentID, vcOrganName,vcOrder,
STUFF((select ',' + vcOrganID from tbOrgan
where o.vcOrder like vcOrder+'%' and o.vcOrder<>vcOrder
order by vcOrder
FOR XML PATH('')), 1, 1, '') as parentIds
from tbOrgan o
order by vcOrder