Database
[{"_id":"123456","Continent":{"Country":[["US",{"State":[[100,{"Product":"Corn","SID":100}],[200,{"Product":"Maze","SID":200}]],}]]}}]
Query
db.collection.aggregate([{$unwind:"$Continent.Country"},{$unwind:"$Continent.Country"},{$unwind:"$Continent.Country.State"},{$match:{"Continent.Country.State.SID":100}},{"$addFields":{"Continent.Country.State":{"$filter":{"input":"$Continent.Country.State","as":"c","cond":{$eq:["$$c.SID",100]}}}}},{$unwind:"$Continent.Country.State"},{$project:{"myProductWithSID100":"$Continent.Country.State"}}])