如： 我有N张表 ,
（出库）T_outProduct内supplier_fid字段为 （集团）T_groupBook 的 _id；
（集团细表）T_groupBookDetail内的 sid 为 （集团）T_groupBook 的 _id，
（出库明细）T_outDetail 内的 sid 为 主表（出库）T_outProduct 的 _id，
（出库明细）T_outDetail 内的 productId 为 （商品表）T_Product 的 _id，
"datar": {
"matchObj": {"_id": "62e89862b717e80001283714","gid": "60d835a6f6a3980001ffe59a"},//搜索串
"tbname": "T_outProduct","M_action": "ChaXun2","sortText": {"register_date": 1},"page": 1,"pageSize": 100,
"lookArr": [//级联串
{"from": "T_groupBook","localField": "supplier_fid","foreignField": "_id","as": "T_groupBook"},
{"from": "T_groupBookDetail","localField": "T_groupBook._id","foreignField": "sid","as": "T_groupBookDetail"},
{"from": "T_outDetail","localField": "_id","foreignField": "sid","as": "T_outDetail"},
{"from": "T_Product","localField": "T_outDetail.productId","foreignField": "_id","as": "T_Product"},
],
"proArr": [//返回串
{
"supplier": 1,
"supplier_fid": 1,
"T_groupBook": {"$arrayElemAt": ["$T_groupBook", 0]},
"T_groupBookDetail": "$T_groupBookDetail",
"T_outDetail": "$T_outDetail",
"T_Product": "$T_Product"
},
],
},
返回结果 ，通过 datar 查询返回的（T_groupBook，T_groupBookDetail，T_outDetail，T_Product）都是独立的数组，
data: [{
"_id": "62e89862b717e80001283714",
"supplier": "红太阳彩印",
"storeLocation": "默认",
"type": "商品",
"outNumber": "SPCK22083034",
"names": "超感超白",
"orderNums": "",
"detail": "",
"amount": 3013.5,
"discount": "",
"dueAmount": 3013.5,
"images": "",
"files": "",
"remark": "",
"register_date": 1659410437634,
"up_time": 1659410437634,
"uid": "60d8324be22fbe000119355d",
"gid": "60d835a6f6a3980001ffe59a",
"supplier_fid": "60d83b3b70f7740001e0ba5c",
"T_groupBook": {
"_id": "60d83b3b70f7740001e0ba5c",
"nickname": "红太阳彩印",
"username": "红太阳彩印公司",
"groupCode": "HTYCY1",
"telphone": "",
"deliveryMethod": 1003,
"moneyMethod": 1002,
"otherAccount": "",
},
"T_groupBookDetail": [{
"_id": "623d71041a124e0001e5e7d7",
"name": "红太阳",
"sex": 0,
}],
"T_outDetail": [{
"_id": "62e89863cc12f40001a4d6d2",
"productId": "6170da909157120001a6c275",
"quantity": 1225,
}],
"T_Product": [{
"_id": "6170da909157120001a6c275",
"name": "超感超白",
"brand": "",
"size": "787*1092",
}]
}]
而我想要的返回结果如下：
data: [{
"_id": "62e89862b717e80001283714",
"supplier": "红太阳彩印",
"outNumber": "SPCK22083034",
"names": "超感超白",
"T_outDetail": [{
"_id": "62e89863cc12f40001a4d6d2",
"T_Product": {
"_id": "6170da909157120001a6c275",
"name": "超感超白",
"uid": "60e905d43b7d3500011a171b",
"gid": "60d835a6f6a3980001ffe59a",
}
"quantity": 1225,
"register_ip": ""
}],
"amount": 3013.5,
"dueAmount": 3013.5,
"uid": "60d8324be22fbe000119355d",
"gid": "60d835a6f6a3980001ffe59a",
"T_groupBook": {
"_id": "60d83b3b70f7740001e0ba5c",
"friendid": 535,
"nickname": "红太阳彩印",
"username": "红太阳彩印公司",
"groupCode": "HTYCY1",
"deliveryMethod": 1003,
"moneyMethod": 1002,
"gid": "60d835a6f6a3980001ffe59a",
"sid": "60d83b3b70f7740001e0ba5c",
"hideMoney": 0,
"T_groupBookDetail":[{
"_id": "60d83b3b70ffrrgr0ba5c",
"name":"张三",
"position": "主管",
"sex": 0
}]
}
}],