select UId,UName,stuff((select ‘,‘+RName from USER_SHOW where a.UId = UId for xml path(‘‘)),1,1,‘‘) as RName from USER_SHOW as a group by UId,UName
合并重复
原文：https://www.cnblogs.com/ly-03-04/p/12182140.html
