Mongoose查询中多层关联字段填充失败问题求助

现有模型定义 #

User模型 #

const userSchema = new mongoose.Schema(
  {
    name: { type: String, min: 3, max: 20, required: true },
    email: { type: String, required: true, unique: true },
    password: { type: String, min: 3, max: 50, required: true },
    blogs: [
      {
        type: mongoose.SchemaTypes.ObjectId,
        type: String,
        ref: "Blog",
        required: false,
        default: [],
      },
    ],
    comments: [
      {
        type: mongoose.SchemaTypes.ObjectId,
        type: String,
        ref: "Comment",
        required: false,
        default: [],
      },
    ],
  },
  { timestamps: true, collection: "users" }
);

Comment模型 #

const commentSchema = new mongoose.Schema(
  {
    title: { type: String, min: 1, max: 25, required: true },
    content: { type: String, min: 1, max: 250, required: true },
    author: {
      type: mongoose.SchemaTypes.ObjectId,
      ref: "User",
      required: true,
    },
    blogRef: { type: mongoose.SchemaTypes.ObjectId, ref: "Blog" },
  },
  { timestamps: true, collection: "comments" }
);

Blog模型 #

const blogSchema = new mongoose.Schema(
  {
    title: { type: String, min: 3, max: 20, required: true },
    content: { type: String, required: true },
    likes: { type: Number, required: true, default: 0 },
    author: { type: mongoose.SchemaTypes.ObjectId, ref: "User" },
    comments: [
      { type: mongoose.SchemaTypes.ObjectId, ref: "Comment", default: [] },
    ],
  },
  { timestamps: true, collection: "blogs" }
);

需求与错误写法 #

需求：查询所有Blog数据，同时填充以下内容：

• Blog自身的author字段
• Blog的comments数组
• 每个Comment中的author字段

错误写法：

const blogs = await Blog.find()
  .populate("author")
  .populate("comments")
  .populate("author");

问题分析 #

1. 重复调用populate("author")无意义：多次填充同一个字段不会产生额外效果，属于冗余代码。
2. 未处理嵌套填充：当前写法仅填充了Blog的comments数组，但没有进一步填充每个Comment内部的author字段，这是无法实现需求的核心原因。
3. User模型存在语法错误：blogs和comments数组中重复定义了type属性（先写ObjectId后写String），最终type会被覆盖为String，导致Mongoose无法识别ObjectId关联，直接影响后续填充功能，必须修正。

修正方案 #

第一步：修复User模型的语法错误 #

将blogs和comments数组中的重复type删除，保留mongoose.SchemaTypes.ObjectId：

blogs: [
  {
    type: mongoose.SchemaTypes.ObjectId,
    ref: "Blog",
    required: false,
    default: [],
  },
],
comments: [
  {
    type: mongoose.SchemaTypes.ObjectId,
    ref: "Comment",
    required: false,
    default: [],
  },
],

第二步：实现嵌套填充 #

使用Mongoose的嵌套填充语法，通过对象配置实现多层关联填充：

写法一：链式调用嵌套填充

const blogs = await Blog.find()
  .populate("author") // 填充Blog的author
  .populate({
    path: "comments", // 填充Blog的comments数组
    populate: {
      path: "author" // 填充每个Comment的author
    }
  });

写法二：数组形式批量配置填充

const blogs = await Blog.find().populate([
  { path: "author" },
  {
    path: "comments",
    populate: { path: "author" }
  }
]);

两种写法效果一致，均可实现需求中的三层关联数据填充。

内容的提问来源于stack exchange，提问作者Shadq