db={"chat":[{"id":"4hWsHam3ZZpoyIw44q3D","title":"Chat example","create-date":1674476855918,"participants":["63ce54460aeee5e72c778d90","63ce54460aeee5e72c778d92"],"owner_id":"63ce54460aeee5e72c778d90","last_message":null,"unread":5},{"id":"Anjrr9RCWFzq030Cwz7S","title":"New chat One","create-date":1674476909054,"participants":["63ce54460aeee5e72c778d90","63ce54460aeee5e72c778d96"],"owner_id":"63ce54460aeee5e72c778d90","last_message":null,"unread":1}],message:[{"id":"tzwekCiCLSXJ4tfdQuHH","chat_id":"4hWsHam3ZZpoyIw44q3D","from_id":"63ce54460aeee5e72c778d92","create_date":1674557062031,"body":"text","update_at":0,"viewed":false},{"id":"7YqhhS1-EfMRSZtGCH0Z","chat_id":"Anjrr9RCWFzq030Cwz7S","from_id":"63ce54460aeee5e72c778d96","create_date":1674575017115,"body":"text","update_at":0,}]}

db.chat.aggregate([{$match:{participants:"63ce54460aeee5e72c778d90",}},{$lookup:{from:"message",localField:"id",foreignField:"chat_id",pipeline:[{$sort:{created:-1}},{$limit:1}],as:"last_message",}},{$unwind:{path:"$last_message",preserveNullAndEmptyArrays:true}},{$project:{last_message:"$last_message"}}])