Node Js和Sequalize model从两个表中获取数据

const Sequelize = require('sequelize');

// 创建Sequelize实例，配置数据库连接信息
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql',
});

// 定义表的模型
const User = sequelize.define('User', {
  name: Sequelize.STRING,
});

const Post = sequelize.define('Post', {
  title: Sequelize.STRING,
  content: Sequelize.TEXT,
});

// 定义表之间的关联关系
User.hasMany(Post);
Post.belongsTo(User);

// 从两个表中获取数据
User.findAll({
  include: [Post], // 包含关联表的数据
}).then(users => {
  users.forEach(user => {
    console.log(user.name);
    user.Posts.forEach(post => {
      console.log(post.title);
    });
  });
}).catch(err => {
  console.error(err);
});