Database

[{"_id":"999999999","brand":"BR","division":"331","department":"3314","productSeasons":[{"season":"FA","year":"2020","status":"ACTIVE","design":"DESIGN1"},{"season":"FA","year":"2020","status":"ACTIVE","design":"DESIGN2"},{"season":"SU","year":"2020","status":"ACTIVE","design":"DESIGN1"}]}]

Query

db.collection.aggregate([{"$unwind":"$productSeasons"},{$match:{"productSeasons.season":"FA","productSeasons.year":"2020","productSeasons.status":"ACTIVE"}},{$group:{"_id":"$_id","data":{$push:"$$ROOT"}}},{"$project":{"_id":1,"department":{$first:"$data.department"},"productSeasons":"$data.productSeasons"}}])

Result