SELECT tg2.group_id,tg2.group_name FROM t_group tg1 LEFT JOIN t_group tg2 ON tg1.group_pid = tg2.group_id WHERE tg1.group_name = '区域管理部'
转载于:https://www.cnblogs.com/yumingzhao/p/9774086.html
SELECT tg2.group_id,tg2.group_name FROM t_group tg1 LEFT JOIN t_group tg2 ON tg1.group_pid = tg2.group_id WHERE tg1.group_name = '区域管理部'
转载于:https://www.cnblogs.com/yumingzhao/p/9774086.html