[{"id":"PRODUCT1","name":"Product 1","active":true,"categories":[{"id":"CAT-1","active":true,"subcategories":[{"id":"SUBCAT-1","active":false},{"id":"SUBCAT-2","active":true}]},{"id":"CAT-2","active":false,"subcategories":[{"id":"SUBCAT-3","active":true}]}]}]

db.collection.aggregate([{"$addFields":{"categories":{"$filter":{"input":"$categories","cond":{$eq:["$$this.active",true]}}}}},{"$addFields":{"categories":{"$map":{"input":"$categories","in":{"$mergeObjects":["$$this",{"subcategories":{"$filter":{"input":"$$this.subcategories","cond":{$eq:["$$this.active",true]}}}}]}}}}}])