SELECT
a.* ,
CASE
WHEN a.parent_id != '0' THEN
( SELECT name FROM sys_menu WHERE id = a.parent_id ) ELSE 0
END AS 'parentName'
FROM
sys_menu a
ORDER BY
a.sort ASC
sql 自关联
最新推荐文章于 2023-12-18 22:30:30 发布
SELECT
a.* ,
CASE
WHEN a.parent_id != '0' THEN
( SELECT name FROM sys_menu WHERE id = a.parent_id ) ELSE 0
END AS 'parentName'
FROM
sys_menu a
ORDER BY
a.sort ASC