Hello I want to get category and it's child categories product collection base on the custom attribute values.
like 3 is parent category and 31,32,33,34,35 all are it's child categories
then i want all the product which have color "Red" in 3,31,32,33,34,35 categories.
Below collection will sure work for you.
hope this could solve your problem