Database
db={"labels":[{"_id":ObjectId("6234364c406b5e0bd4f9bb1b"),"is_deleted":false,"labelName":"cats","description":"cats ","datasetId":ObjectId("62343589f8afb4001e27a00c"),"createdAt":ISODate("2022-03-18T07:35:40.622Z"),"updatedAt":ISODate("2022-03-18T07:35:40.622Z"),"__v":0}],"images":[{"_id":ObjectId("62382d400c0082003122a12b"),"is_deleted":false,"labels":[{"_id":ObjectId("623d76c55ecb9849943020ab"),"labelId":ObjectId("6234364c406b5e0bd4f9bb1b"),"xmax":10,"xmin":20,"ymax":20,"ymin":20},{"_id":ObjectId("623d76c55ecb9849943020ac"),"labelId":ObjectId("6234364c406b5e0bd4f9bb1c"),"xmax":50,"xmin":60,"ymax":70,"ymin":80},{"_id":ObjectId("623d76c55ecb9849943020ab"),"labelId":ObjectId("6234364c406b5e0bd4f9bb1b"),"xmax":100,"xmin":200,"ymax":300,"ymin":400}],"img_name":"6911578680130170881655.jpg","img_originalname":"cats_00001.jpg","img_desc":"Cyber Sercurity multi upload","img_uri":"http://localhost:4031/resources/images/2022/3/21/6911578680130170881655.jpg","img_path":"/resources/images/2022/3/21/6911578680130170881655.jpg","datasetId":ObjectId("62382d400c0082003122a0e8"),"createdAt":ISODate("2022-03-21T07:46:08.431Z"),"updatedAt":ISODate("2022-03-25T08:01:09.993Z"),"__v":0}]}
Query
db.images.aggregate([{"$addFields":{"labels":{"$filter":{"input":"$labels","as":"lab","cond":{"$eq":["$$lab.labelId",ObjectId("6234364c406b5e0bd4f9bb1b")]}}}}},{$unwind:"$labels"},{$lookup:{from:"labels",let:{labelId:"$labels.labelId",label:"$labels"},pipeline:[{$match:{$expr:{$eq:["$_id","$$labelId"]}}},{$replaceRoot:{newRoot:{$mergeObjects:["$$label","$$ROOT"]}}}],as:"labels"}},{$unwind:"$labels"},{$group:{_id:"$_id",createdAt:{$first:"$createdAt"},updatedAt:{$first:"$updatedAt"},datasetId:{$first:"$datasetId"},is_deleted:{$first:"$is_deleted"},img_uri:{$first:"$img_uri"},img_originalname:{$first:"$img_originalname"},img_name:{$first:"$img_name"},img_desc:{$first:"$img_desc"},img_path:{$first:"$img_path"},labels:{$push:"$labels"}}}])