mongodb获取用户道具(mongodb连表查询)
db.getCollection("base").aggregate(
[
{
"$lookup" : {
"localField" : "id",
"from" : "item",
"foreignField" : "user_id",
"as" : "item1"
}
},
{
"$unwind" : {
"path" : "$item1"
}
},
{
"$match" : {
"id" : NumberLong(10000),
"item1.id" : NumberLong(1001)
}
}
]
);