mongoose嵌套数组的外键关联

Question

const CommentsSchema = new Schema({
  user: { type: Schema.Types.ObjectId, ref: 'User', require: true },
  article: { type: Schema.Types.ObjectId, ref: 'Article', require: true },
  content: { type: String, require: true },
  created_at: { type: Date, default: Date.now },
  thumbsUp: { type: Number, default: 0 },
  thumbsDown: { type: Number, default: 0 },
  isChecked: { type: Boolean, default: false },
  replies: [{
    user: { type: Schema.Types.ObjectId, ref: 'User', require: true },
    content: { type: String, require: true },
    created_at: { type: Date, default: Date.now },
    thumbsUp: { type: Number, default: 0 }
  }]
})

想要得到

{
    user: {
        
    },
    ...,
    replise: [
        user: {
            
        },
        ...
    ]
}

形式的查询结果

请问如何在数组中关联其他表进行查询

Answer 1

populate('replies.user')

自问自答了，是自己傻逼一直以为populate('replies.user')不起作用是这样写不对，后来发现是数据库字段名没对应