[{"_id":1,"main_array":[{"subid":222,"subarray":[{"name":"hari","status":1},{"name":"henry","status":1}]},{"subid":333,"subarray":[{"name":"james","status":0},{"name":"jason","status":1}]}]},{"_id":2,"main_array":[{"subid":222,"subarray":[{"name":"alex","status":1},{"name":"anna","status":1}]},{"subid":333,"subarray":[{"name":"bob","status":0},{"name":"bunny","status":1}]}]}]

db.collection.aggregate({$unwind:"$main_array"},{$match:{"main_array.subid":222}})