SQL 子查詢 文字累加

select u.*,
(select CONVERT(nvarchar(max),f.RID ) + ','
from UserRoleRelation f
 where u.UID = f.UID for xml path('')) role
from SYS_User u