sql server 一对多单行显示

SELECT [USERNAME], [USERACCOUNT]
    , [ROLENAME] = stuff((
        SELECT ',' + [ROLENAME]
        FROM [TEST].[dbo].[T_Role]
        WHERE [USERACCOUNT] = a.[USERACCOUNT]
        FOR XML path('')
    ), 1, 1, '')
FROM [TEST].[dbo].[T_Role] a
GROUP BY [USERNAME], [USERACCOUNT]