nodejs + mongoDB 做两表关联查询

1.创建一个 user（被关联的表）
const UserSchema = new mongoose.Schema({

name: { // 用户姓名
type: String,
},
loginname: { // 用户姓名
type: String,
},

});
const TABLE_NAME=“users”;
const DATABASE_NAME=“node_dev”;
mongoose.model(‘users’, UserSchema );
2.创建一个 article
var Schema = mongoose.Schema;
var articleSchema = new Schema( {
content: {type: String},
author_id: {
type: Schema.ObjectId,
ref:‘users’ //关联用户表
},
}
);
find(obj).sort(sort).skip(skip).limit(pageSize).populate(“author_id”);
注：author_id则变成一个对象直接取对象属性即可