getRoleFunction === * 查询指定的登录用户是否能访问某个功能 select * from core_role_function where role_id in ( select role_id from core_user_role where user_id =#userId# and org_id=#orgId# ) and FUNCTION_ID = (select id from core_function where code=#code#) getRoleChildrenFunction === * 查询指定角色和所在机构的人某个功能下的子功能列表 select sf.code from core_role_function rf left join core_function sf on rf.function_id=sf.id where rf.role_id in ( select role_id from core_user_role where user_id =#userId# and org_id=#orgId# ) and rf.FUNCTION_ID in (select id from core_function where parent_id= #parentId# )