select a.memberguid,group_concat(b.username) from membermanager a
left join k_manager b
on a.managerguid=b.managerguid
where a.memberguid='b59948c6-5f60-4dd3-aced-af93fc881b4a'
group by memberguid
left join k_manager b
on a.managerguid=b.managerguid
where a.memberguid='b59948c6-5f60-4dd3-aced-af93fc881b4a'
group by memberguid