如何在mongoose中实现和mysql一样的子查询？

const mongoose = require('mongoose');

// 创建Schema
const userSchema = new mongoose.Schema({
  name: String,
  age: Number,
  posts: [{ type: mongoose.Schema.Types.ObjectId, ref: 'Post' }]
});

const postSchema = new mongoose.Schema({
  title: String,
  content: String
});

// 创建Model
const User = mongoose.model('User', userSchema);
const Post = mongoose.model('Post', postSchema);

// 查询用户及其对应的文章
User.findOne({ name: 'John' })
  .populate('posts')
  .exec((err, user) => {
    if (err) {
      console.error(err);
      return;
    }
    console.log(user);
  });