select m.id,m.pattern,r.id as rid,r.name,r.name_zh
from menu m
left join menu_role mr on m.id=mr.id
left join `role` r on mr.rid=r.id
select m.id,m.pattern,r.id as rid,r.name,r.name_zh
from menu m
left join menu_role mr on m.id=mr.id
left join `role` r on mr.rid=r.id