怎么做菜单栏目

Question

谁有好的办法把数据库中的数据查出来，变成菜单。

Answer 1

一个sql
[code="sql"]SELECT m.*
FROM (SELECT DISTINCT gm.menuid
FROM sys_group_menu gm
WHERE gm.groupid IN (SELECT gu.groupid
FROM sys_group_user gu
INNER JOIN sys_group g ON gu.groupid = g.id
AND g.isdelete <> '2'
WHERE gu.userid = '1')) n
LEFT JOIN sys_menu m ON m.ID = n.menuid
WHERE m.isdelete <> '2'[/code]