sql 行转列的问题

之前是这种效果，

要变成这种效果

select b.id,left(userlist,len(userlist)-1) as paths from(
select id,(
select userid+',' from test2 where id=a.id order by id for xml path(''))
 as userlist
from test2 a
group by id
)b