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 = '区域管理部'
