Mongo关联查询两张表中分别满足某些条件的记录

select *  from equity t1 left join equity_ext t2 on t1.quoteId =t2.quoteId 
 and t1.regionId = 6 and t1.listedStatus=1 and t1.securityType=7
 and t2.isPTP != 0

db.equity.aggregate([
    {
        $lookup: {
            from: "equity_ext", // 指定要连接的集合
            localField: "quoteId", // 指定当前集合中用于匹配的字段
            foreignField: "quoteId", // 指定要连接的集合中的字段
            as: "ext" // 指定连接结果的字段名
        }
    },
    {
        $unwind: "$ext" // 展开连接结果，使其成为单独的文档
    },
    {
        $match: {
            regionId: 6,
            listedStatus: 1,
            securityType: 7,
            "ext.isPTP": { $ne: 0 } // 非0值，即不等于0
        }
    }
]);

db.equity.aggregate([
  {
    $match: {
      regionId: 6,
      listedStatus: 1,
      securityType: 7
    }
  },
  {
    $lookup: {
      from: "equity_ext",
      localField: "quoteId",
      foreignField: "quoteId",
      as: "equity_ext_docs"
    }
  },
  {
    $unwind: {
      path: "$equity_ext_docs",
      preserveNullAndEmptyArrays: true
    }
  },
  {
    $match: {
      "equity_ext_docs.isPTP": { $ne: 0 }
    }
  },
  {
    $project: {
      _id: 1,
      quoteId: 1,
      regionId: 1,
      listedStatus: 1,
      securityType: 1,
      equity_ext_docs: {
        quoteId: 1,
        isPTP: 1
      }
    }
  }
]);