三表联查获取当前用户权限菜单

三表联查，获取当前用户的权限菜单JSON数据

select resource.* from role_user
  inner join role_resource 
  on role_user.roel_id = role_resource.roel_id
  inner join resource 
  on role_resource.resource_id = resource.id
  where role_user.user_id = 1