db={"project":[{"_id":ObjectId("6102780c27474af56cf6734b"),"channel":"instagram","status":"new","analysis_type":"detail","batch_ids":["6102780c27474af56cf6734d","6102780d27474af56cf6734f",]}],"batch":[{"_id":ObjectId("6102780c27474af56cf6734d"),"keyword":{"keyword":"tomato","keyword_type":"hashtag"},"channel":"instagram","post_datetime":ISODate("2021-07-29T18:42:36.306Z"),"analysis_type":"detail","status":"new",},{"_id":ObjectId("6102780d27474af56cf6734f"),"keyword":{"keyword":"tomato","keyword_type":"hashtag"},"channel":"instagram","post_datetime":ISODate("2021-07-29T18:42:36.306Z"),"analysis_type":"detail","status":"done",}]}

db.project.aggregate([{"$lookup":{"from":"batch","let":{batchObjectIds:{$map:{input:"$batch_ids",as:"batch_id",in:{"$toObjectId":"$$batch_id"}}}},"pipeline":[{$match:{$expr:{$in:["$_id","$$batchObjectIds"]}}},{$project:{_id:1,status:1}}],"as":"batch_ids"}},])