SELECT
a.serial_id,
d.name,
c.name,
FROM permission a
INNER JOIN policies b ON (
a.permission_refer = b.permission_refer
)
INNER JOIN actions c ON (
c.permission_refer = b.permission_refer
)
INNER JOIN resource d ON (
d.permission_refer = c.permission_refer
)
WHERE
a.user_id = '11'
;