mysql基于递归查询组织结构树 1.查询语句 -查询层级 WITHRECURSIVEcteAS( -查询父级数据 SELECTGROUP_ID_,KEY_,name_,parent_id_,1ASlevel FROMos_group WHEREparent_id_='0'andDIM_ID_=2 UNIONALL -查询子级数据 SELECTt.GROUP_ID_asGROUP_ID_,t.KEY_asKEY_,t.name_asname_,t.parent_id_asparent_id_,cte.level+1 FROMos_groupt JOINcteONt.parent_id_=ct...