[{"_id":ObjectId("633ebce93642850dfa00dbb7"),"messageType":0,"groupId":"group-A","message":"my 1st message","senderId":"user-A","createdAt":ISODate("2022-11-06T16:32:57.000Z"),"__v":0,"updatedAt":ISODate("2022-11-06T14:28:03.478Z")},/** 2*/{"_id":ObjectId("633ebd553642850dfa00dbb9"),"messageType":0,"groupId":"group-A","message":"UserB -1st message","senderId":"user-B","createdAt":ISODate("2022-11-13T16:34:45.000Z"),"__v":0,"updatedAt":ISODate("2022-11-13T14:28:03.478Z")},/** 3*/{"_id":ObjectId("633fd4b5cdf14144b040d63b"),"messageType":0,"groupId":"group-X","message":"User x 1st message in X-group","senderId":"User-X","createdAt":ISODate("2022-11-15T12:26:45.000Z"),"__v":0,"updatedAt":ISODate("2022-11-15T14:28:03.478Z")},/** 4*/{"_id":ObjectId("6343c6c0dbfa6356d476a642"),"messageType":0,"groupId":"group-A","message":"userA last message in groupA","senderId":"user-A","createdAt":ISODate("2022-11-19T12:16:16.000Z"),"__v":0,"updatedAt":ISODate("2022-11-19T14:28:03.478Z")},/** 5*/{"_id":ObjectId("63451926177a364ce8909d33"),"messageType":0,"groupId":"group-A","message":"secong mesage","senderId":"user-B","createdAt":ISODate("2022-11-23T12:20:06.000Z"),"__v":0,"updatedAt":ISODate("2022-11-23T14:28:03.478Z")}]

db.collection.aggregate({$match:{"senderId":"user-A","groupId":"group-A"}},{"$sort":{"createdAt":-1}},{"$limit":1},{"$lookup":{"from":"collection","localField":"groupId","foreignField":"groupId","as":"_result","let":{"last_createdAt":"$createdAt"},"pipeline":[{"$match":{"senderId":{"$ne":"user-A"},"$expr":{"$lte":["$createdAt","$$last_createdAt"]}}},{"$sort":{"createdAt":-1}},{"$limit":1}]}},{"$replaceRoot":{"newRoot":{"$arrayElemAt":["$_result",0]}}})