Interesting use case. One of my clients recently went through a similar restructuring on their eCommerce platform especially for men bamboo sleepwear based products, and we had to run hierarchical queries like this to audit team roles across multiple branches. Queries like these really help visualize organizational depth and optimize internal operations.