db={coll:[{"_id":{"$oid":"66012b133fa457ed3a999ca7"},"surveyName":"new survey","surveyStartDate":{"$date":"2024-03-26T21:00:00.000Z"},"surveyEndDate":{"$date":"2024-03-29T21:00:00.000Z"},"surveyTargetGender":"all","surveyTargetHobbies":["6547a0f8aa29e1d75ba8d8a2","6547a0f9aa29e1d75ba8d8a4"],"createdAt":{"$date":"2024-03-25T07:43:15.298Z"},"updatedAt":{"$date":"2024-03-25T07:43:18.314Z"}},{"_id":{"$oid":"66012b133fa457ed3a999ca8"},"surveyName":"new survey","surveyStartDate":{"$date":"2024-03-26T21:00:00.000Z"},"surveyEndDate":{"$date":"2024-03-29T21:00:00.000Z"},"surveyTargetGender":"all","surveyTargetHobbies":["6547a0f9aa29e1d75ba8d8a4","6547a0f9aa29e1d75ba8d8a1"],"createdAt":{"$date":"2024-03-25T07:43:15.298Z"},"updatedAt":{"$date":"2024-03-25T07:43:18.314Z"}}],hobbies:[{"_id":{"$oid":"6547a0e0e1ed3d290303c04f"},"title":"Dating","subHobbies":[{"title":"Long-term Relationship","_id":{"$oid":"6547a0f8aa29e1d75ba8d8a2"}},{"title":"Short-term Relationship","_id":{"$oid":"6547a0f9aa29e1d75ba8d8a4"}}]},{"_id":{"$oid":"6547a0e0e1ed3d290303c04c"},"title":"Running","subHobbies":[{"title":"Long-distance Running","_id":{"$oid":"6547a0f8aa29e1d75ba8d8a0"}},{"title":"Short-distance Running","_id":{"$oid":"6547a0f9aa29e1d75ba8d8a1"}}]}]}

db.coll.aggregate([{$lookup:{from:"hobbies",let:{vid:{$map:{input:"$surveyTargetHobbies",in:{$toObjectId:"$$this"}}}},pipeline:[{$match:{$expr:{$gt:[{$size:{$setIntersection:["$subHobbies._id","$$vid"]}},0]}}},{$project:{_id:0,subHobbies:{$filter:{input:"$subHobbies",cond:{$in:["$$this._id","$$vid"]}}}}}],as:"surveyTargetHobbies"}},{$set:{surveyTargetHobbies:{$reduce:{input:"$surveyTargetHobbies.subHobbies.title",initialValue:[],in:{$concatArrays:["$$value","$$this"]}}}}}])