db={doc1:[{"version":123456,"doc":{"code":"A1","name":"some document A1","doc2CodeArray":[{"code":"B01"},{"code":"B02"},{"code":"B03"},{"code":"B04"},{"code":"B05"},{"code":"B06"}]}},{"version":123457,"doc":{"code":"A2","name":"some document A2","doc2CodeArray":[{"code":"B07"},{"code":"B08"},{"code":"B09"},{"code":"B10"},{"code":"B11"},{"code":"B12"}]}}],doc2:[{"version":567890,"doc":{"code":"B01","valueArray":[{"valueType":"int","valueData":"1"}],"doc2Type":{"code":"C1"}}},{"version":567890,"doc":{"code":"B02","valueArray":[{"valueType":"int","valueData":"2"}],"doc2Type":{"code":"C2"}}},{"version":567890,"doc":{"code":"B03","valueArray":[{"valueType":"int","valueData":"3"}],"doc2Type":{"code":"C3"}}},{"version":567890,"doc":{"code":"B04","valueArray":[{"valueType":"int","valueData":"4"}],"doc2Type":{"code":"C4"}}},{"version":567890,"doc":{"code":"B05","valueArray":[{"valueType":"int","valueData":"5"}],"doc2Type":{"code":"C5"}}},{"version":567890,"doc":{"code":"B06","valueArray":[{"valueType":"int","valueData":"6"},{"valueType":"str","valueData":"F"}],"doc2Type":{"code":"C6"}}},{"version":567890,"doc":{"code":"B07","valueArray":[{"valueType":"int","valueData":"1"}],"doc2Type":{"code":"C1"}}},{"version":567890,"doc":{"code":"B08","valueArray":[{"valueType":"int","valueData":"2"}],"doc2Type":{"code":"C2"}}},{"version":567890,"doc":{"code":"B09","valueArray":[{"valueType":"int","valueData":"3"}],"doc2Type":{"code":"C3"}}},{"version":567890,"doc":{"code":"B10","valueArray":[{"valueType":"int","valueData":"4"}],"doc2Type":{"code":"C4"}}},{"version":567890,"doc":{"code":"B11","valueArray":[{"valueType":"int","valueData":"5"}],"doc2Type":{"code":"C5"}}},{"version":567890,"doc":{"code":"B12","valueArray":[{"valueType":"int","valueData":"6"}],"doc2Type":{"code":"C6"}}},]}

db.doc1.aggregate([{$lookup:{from:"doc2",let:{doc2CodeArray:"$doc.doc2CodeArray.code"},pipeline:[{$match:{$expr:{$in:["$doc.code","$$doc2CodeArray"]}}},{$project:{_id:0,"doc2TypeCode":"$doc.doc2Type.code","doc2ValueArray":"$doc.valueArray"}}],as:"doc2Items"}},{$project:{_id:0,"doc1Code":"$doc.code","doc1Name":"$doc.name","doc2Items":"$doc2Items"}}])