GoooQo v0.2.2 已经发布，OQM 技术的 Golang 实现

 import . "github.com/doytowin/goooqo/core" type MenuEntity struct { IntId ParentId *int `json:"parentId,omitempty"` Name *string `json:"name,omitempty"` } type MenuQuery struct { PageQuery Id *int // many-to-one: // 查询特定父菜单的子菜单： // parent_id IN (SELECT id FROM t_menu WHERE [conditions]) Parent *MenuQuery `entitypath:"menu" localField:"ParentId"` // one-to-many: // 查询特定子菜单的父菜单： // id IN (SELECT parent_id FROM t_menu WHERE [conditions]) Children *MenuQuery `entitypath:"menu" foreignField:"ParentId"` /** many-to-many: 查询特定用户可以访问的菜单： id IN ( SELECT menu_id FROM a_perm_and_menu WHERE perm_id IN ( SELECT perm_id FROM a_role_and_perm WHERE role_id IN ( SELECT role_id FROM a_user_and_role WHERE user_id IN ( SELECT id FROM t_user WHERE [conditions] ) ) ) )*/ User *UserQuery `entitypath:"menu,perm,role,user"` }