用另一个值连接sql server和group中的值ms sql server

I have simple select

我有简单的选择

select distinct  UserName, Company from Users inner join Companies on Users.UserName = Companies.UserFullName
select distin