sql语句

1.up.menu_id 是单个

SELECT p.*
FROM user_info AS ui
JOIN power AS up ON ui.type_id = up.type_id
JOIN menu AS p ON up.menu_id = p.m_id
WHERE ui.user_id = 1;

2.up.menu_id 是数组

SELECT p.*
FROM user_info AS ui
JOIN power AS up ON ui.type_id = up.type_id
JOIN menu AS p ON FIND_IN_SET(p.m_id, up.menu_id) > 0
WHERE ui.user_id = 1;

3.order字段正序排

SELECT p.*
FROM user_info AS ui
JOIN power AS up ON ui.type_id = up.type_id
JOIN menu AS p ON FIND_IN_SET(p.m_id, up.menu_id) > 0
WHERE ui.user_id = 1 ORDER BY p.order ASC;

4.order字段倒叙

SELECT p.*
FROM user_info AS ui
JOIN power AS up ON ui.type_id = up.type_id
JOIN menu AS p ON FIND_IN_SET(p.m_id, up.menu_id) > 0
WHERE ui.user_id = 1 ORDER BY p.order DESC;