如何在发布新记录时包含user_id (foreignKey)？

CREATE TABLE users (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL
);

CREATE TABLE posts (
    id INT PRIMARY KEY AUTO_INCREMENT,
    title VARCHAR(255) NOT NULL,
    content TEXT NOT NULL,
    user_id INT,
    FOREIGN KEY (user_id) REFERENCES users(id)
);

const mysql = require('mysql');
const connection = mysql.createConnection({
    host: 'localhost',
    user: 'your_username',
    password: 'your_password',
    database: 'your_database'
});

connection.connect();

const newPost = {
    title: 'New Blog Post',
    content: 'This is the content of the new blog post.',
    user_id: 1 // 假设用户ID为1
};

const query = 'INSERT INTO posts (title, content, user_id) VALUES (?, ?, ?)';
connection.query(query, [newPost.title, newPost.content, newPost.user_id], (error, results) => {
    if (error) throw error;
    console.log('Post inserted successfully!');
});

connection.end();