假如有这么3张表
1、省份表(test_provinces)
db.test_provinces.insertMany([{
name:'广东省'
},
{
name:'广西省'
}
])
2.城市表(test_city)
db.test_city.insertMany([{
name:'深圳市',
province_id:ObjectId("63d78a3a07781d41000431aa")
},
{
name:'广州市',
province_id:ObjectId("63d78a3a07781d41000431aa")
}
])
3.区域表 (test_district)
db.test_district.insertMany([
{
name:'天河区',
city_id:ObjectId("63d78add07781d41000431ad")
},
{
name:'海珠区',
city_id:ObjectId("63d78add07781d41000431ad")
},
{
name:'福田区',
city_id:ObjectId("63d78add07781d41000431ac")
}
])
重点来了,如何进行连表并返回以下数据格式
{
name:'广东省',
city:[{
name:'深圳市',
district:[{
name:'福田区'
}]
}]
}