在填充的对象数组中查找一个值mongdb - lodash

const mongoose = require('mongoose');
const _ = require('lodash');

// 定义模式和模型
const userSchema = new mongoose.Schema({
  name: String,
  age: Number,
  address: String
});

const orderSchema = new mongoose.Schema({
  userId: mongoose.Schema.Types.ObjectId,
  product: String,
  quantity: Number
});

const User = mongoose.model('User', userSchema);
const Order = mongoose.model('Order', orderSchema);

// 填充对象数组
const orders = [
  { userId: '60a4c4e8d4f8e60015a3e7a1', product: 'Apple', quantity: 5 },
  { userId: '60a4c4e8d4f8e60015a3e7a2', product: 'Banana', quantity: 3 },
  { userId: '60a4c4e8d4f8e60015a3e7a3', product: 'Orange', quantity: 2 }
];

// 查找值的函数
async function findValueInArray(value) {
  try {
    // 使用$lookup关联User集合
    const result = await Order.aggregate([
      {
        $lookup: {
          from: 'users',
          localField: 'userId',
          foreignField: '_id',
          as: 'user'
        }
      },
      {
        $match: {
          'user.name': value
        }
      }
    ]);

    // 提取匹配的结果
    const matchedOrders = _.flatMap(result, 'user');

    return matchedOrders;
  } catch (error) {
    console.error(error);
  }
}

// 调用函数并打印结果
findValueInArray('John').then((matchedOrders) => {
  console.log(matchedOrders);
});