hi
tell me does it work

select parentregion,childregion from TABLE group by parentregion,childregion;

same query i applied on EMP table on MGR and EMPNO columns because these columns have the same situation as u have described

Regards