多表联查,花了好长时间写出来的。
如果帮到你了请给我点一个赞哦!!!!
SELECT
p.f_id p_id,
p.f_name p_name,
c.f_id,
c.f_name,
c.f_url
FROM
s_fun c JOIN s_fun p ON c.f_pid = p.f_id
JOIN s_lf lf ON c.f_id = lf.f_id
JOIN LEVEL l ON lf.l_level = l.level
JOIN store s ON l.level = s.s_level
WHERE c.f_ismenu = 1 AND s.s_id = 1