[{_id:"60642127b982sa55299q674444a",subject:"Email 1",body:"Body 1",to:[{email_id:"test1@gmail.com",name:"test 1",date:"2021-10-01 12:00:00"},{email_id:"test2@gmail.com",name:"test 2",date:"2021-10-01 13:00:00"}],cc:[{email_id:"test3@gmail.com",name:"test 3",date:"2021-10-01 14:00:00"},{email_id:"test4@gmail.com",name:"test 4",date:"2021-10-01 15:00:00"}],bcc:[{email_id:"test5@gmail.com",name:"test 5",date:"2021-10-01 16:00:00"},{email_id:"test6@gmail.com",name:"test 6",date:"2021-10-01 17:00:00"}]},{_id:"60642127b982sa55299q674444b",subject:"Email 2",body:"Body 2",to:[{email_id:"test1@gmail.com",name:"test 1",date:"2021-10-01 12:10:00"},{email_id:"test2@gmail.com",name:"test 2",date:"2021-10-01 13:10:00"}],cc:[{email_id:"test3@gmail.com",name:"test 3",date:"2021-10-01 14:10:00"},{email_id:"test4@gmail.com",name:"test 4",date:"2021-10-01 15:10:00"}],bcc:[{email_id:"test5@gmail.com",name:"test 5",date:"2021-10-01 16:10:00"},{email_id:"test6@gmail.com",name:"test 6",date:"2021-10-01 17:10:00"}]}]

db.collection.aggregate([{"$match":{"$or":[{"to.email_id":"test2@gmail.com"},{"cc.email_id":"test2@gmail.com"},{"bcc.email_id":"test2@gmail.com"}]}},{"$project":{subject:1,body:1,concat:{$concatArrays:["$to","$cc","$bcc"]}}},{"$unwind":"$concat"},{"$match":{"concat.email_id":"test2@gmail.com"}},{"$sort":{"concat.date":-1}}])