表1
"_id":"2a0398605f1114*****d69a167ebf9ed"
"name":"A_TL"
"alistArray":[100,101,200,201]
表二
"_id":"2a0398605f1114*****d69a167ebf9ed"
"alistID":"301"
"time":"20-10-10"
------------------------------------------------------
"_id":"2a0398605f1114*****d69a167ebf9ed"
"alistID":"100"
"time":"21-10-10"
------------------------------------------------------
"_id":"2a0398605f1114*****d69a167ebf9ed"
"alistID":"200"
"time":"20-12-10"
------------------------------------------------------
"_id":"2a0398605f1114*****d69a167ebf9ed"
"alistID":"201"
"time":"10-10-10"
------------------------------------------------------
"_id":"2a0398605f1114*****d69a167ebf9ed"
"alistID":"501"
"time":"25-10-10"
遍历【表1】里”alistArray“字段里的所有值，联表查询【表2】里的”alistID“相匹配的数据，
实现结果：
"_id":"2a0398605f1114*****d69a167ebf9ed"
"name":"A_TL"
"alistArray":[100,101,200,201]
"newlist":[
{
"_id":"2a0398605f1114*****d69a167ebf9ed"
"alistID":"100"
"time":"21-10-10"
},
{
"_id":"2a0398605f1114*****d69a167ebf9ed"
"alistID":"200"
"time":"20-12-10"
},
{
"_id":"2a0398605f1114*****d69a167ebf9ed"
"alistID":"201"
"time":"10-10-10"
}
]
db.collection('table1').aggregate() .match({ _id:"2a0398605f1114*****d69a167ebf9ed" }) .lookup({ from: 'table2', let: { aliArr: '$alistArray' }, pipeline: $.pipeline() .match(_.expr($.in(['$alistID', '$$aliArr']))) .done(), as: 'newlist', }) .end()若认为该回答有用，给回答者点个[ 有用 ]，让答案帮助更多的人