db={"issue":[{"_id":"612775fbd237d9769a9fc3e4","tittle":"Weekly Issue1","data":[{"categoryId":"61272e7dd237d9769a9fc3d9","articles":["61272f29d237d9769a9fc3da","61272f29d237d9769a9fc3db"]},{"categoryId":"61272e7dd237d9769a9fc310","articles":["61272f29d237d9769a9fc3dc"]}]}],"category":[{"_id":"61272e7dd237d9769a9fc3d9","name":"News"},{"_id":"61272e7dd237d9769a9fc310","name":"News1"}],"article":[{"_id":"61272f29d237d9769a9fc3da","title":"Some News","url":"https://www.google.com"},{"_id":"61272f29d237d9769a9fc3db","title":"Another News","url":"https://www.google.com"},{"_id":"61272f29d237d9769a9fc3dc","title":"Other News","url":"https://www.google.com"}]}

db.issue.aggregate([{"$lookup":{"from":"category","let":{"data":"$data"},"pipeline":[{"$match":{"$expr":{"$in":["$_id","$$data.categoryId"]}}},{"$addFields":{"articles":{"$arrayElemAt":[{"$filter":{"input":"$$data","as":"d","cond":{"$eq":["$$d.categoryId","$_id"]}}},0]}}},{"$lookup":{"from":"article","localField":"articles.articles","foreignField":"_id","as":"articles"}}],"as":"data"}}])