Database

[{"_id":"111","array1":[{"name":"john","array2":[{"city":"mexico","array3":[{"address":"address1","status":"verified"},{"address":"address2","status":"unverified"}]}]}]},{"_id":"112","array1":[{"name":"john","array2":[{"city":"mexico","array3":[{"address":"address1","status":"unverified"},{"address":"address2","status":"unverified"}]}]}]}]

Query

db.collection.aggregate([{$match:{"array1.array2.array3.status":"verified"}},{$addFields:{array1:{$filter:{input:{$map:{input:"$array1",as:"mapone",in:{"$mergeObjects":["$$mapone",{array2:{$filter:{input:{$map:{input:"$$mapone.array2",as:"maptwo",in:{"$mergeObjects":["$$maptwo",{array3:{$filter:{input:"$$maptwo.array3",as:"three",cond:{$eq:["$$three.status","verified"]}}}}]}}},as:"filtertwo",cond:{$and:[{$gt:[{$size:["$$filtertwo.array3"]},0]},{$eq:["$$filtertwo.city","mexico"]}]}}}}]}}},as:"filterone",cond:{$and:[{$gt:[{$size:["$$filterone.array2"]},0]},{$eq:["$$filterone.name","john"]}]}}}}}])

Result