select u.id,u.name，group_concat(b.名称) from u left join b on find_in_set(b.id,u.部门Id) group by u.id;

find_in_set