[TOC] ### mongoose 關聯查詢 * [ ] 一對多 比如訂單表，一個訂單對應多個商品，訂單和商品屬于一對多 ~~~ async getOrder() { return await this.ctx.model.Order.aggregate([ { $lookup: { from: 'order_item', localField: 'order_id', foreignField: 'order_id', as: 'items' } } ]) } ~~~ >[info] $lookup 主表關聯 > from 關聯子表 > localField 主表id ( 與子表關聯的字段 ) > foreignField 關聯外鍵 （子表和主表關聯的字段） > as 關聯字段 ~~~ [ { "_id": "5d209e01e9d8ac37a0976bfd", "order_id": "1", "uid": "10", "trade": "111", "all_price": "100", "all_num": "2", "status": "0", "items": [ { "_id": "5d209e33e9d8ac37a0976bfe", "order_id": "1", "title": "鼠標", "price": "60", "num": "1" }, { "_id": "5d209e4fe9d8ac37a0976bff", "order_id": "1", "title": "鍵盤", "price": "90", "num": "16" }, { "_id": "5d209e63e9d8ac37a0976c00", "order_id": "1", "title": "液晶屏幕", "price": "160", "num": "90" } ] } ] ~~~