菜单表menu (id,name)用户菜单关系表user_menu (id,menuID,userID) 用户表user (id,name) select b.* from user_menu a inner join menu b on a.menuID = b.id inner join user c on a.userID = c.id where c.id = <uid>
菜单表menu (id,name)
用户菜单关系表user_menu (id,menuID,userID)
用户表user (id,name)