light-apiengine/models/Sql_SysMenu.go

package models

var SqlSelectRoleMenuByUserId = `
SELECT sys_menu.*
FROM
	sys_user
LEFT JOIN
	sys_user_role
ON
	sys_user.id = sys_user_role.user_id
LEFT JOIN
	sys_role_menu
ON
	sys_user_role.role_id = sys_role_menu.role_id
LEFT JOIN
	sys_menu
ON
	sys_menu.id = sys_role_menu.menu_id
WHERE
	sys_user.id = ?
`