select cityName,stuff((select ','+B.Name from CityItemRole A left join Users as B on A.UserId=B.Id where A.CityId=Citys.Id FOR xml PATH('')), 1, 1, '') as roleNames
FROM Citys
--------查询结果
/*
cityName roleNames
上海 张三,王五
宁波 李四,赵六
苏州 王五,赵六
*/