Let's say my parent collection (Category) has a field called locale.

This category may have subcategories and products, and products can be in each subcategory.

What I need is, query the all products, whose parent's locale is "en\_US".

What is the query or script to list it?