SQL stitching the same column values

In SQL, it is sometimes necessary to turn the value of a column into a row, such as the following data, what are the Zumenid with the same path?

A common practice can be found in this article http://www.cnblogs.com/xiashengwang/p/3503554.html

Here is another way to join the value of the concatenation column, using XML implementation. See this article http://www.cnblogs.com/yuefei/p/3799513.html

But this is a little bit more complicated and requires a subquery. SQL is as follows:

Select B.path,  stuff (replace (        (select Zumenid,path from t_zumen c where C.path = B.path FOR XML Auto), ' <c zumenid= "', ', '),        '" path= "' + b.path+ '"/> ', '), ","     ) zumenidsfrom (select distinct path from T_zumen) B--distinct the path first

The effect is as follows:

SQL stitching the same column values