如何将数据库中的项添加到复选列表框？

// 连接数据库
const mysql = require('mysql');
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

connection.connect();

// 查询数据库
const query = 'SELECT id, name FROM items';
connection.query(query, (error, results, fields) => {
  if (error) throw error;

  // 处理查询结果
  const options = results.map(item => ({
    value: item.id,
    text: item.name
  }));

  // 动态生成复选列表框
  const checkboxList = document.createElement('div');

  // 添加选项
  options.forEach(option => {
    const checkbox = document.createElement('input');
    checkbox.type = 'checkbox';
    checkbox.value = option.value;
    checkbox.text = option.text;

    const label = document.createElement('label');
    label.appendChild(checkbox);
    label.appendChild(document.createTextNode(option.text));

    checkboxList.appendChild(label);
  });

  // 显示复选列表框
  document.body.appendChild(checkboxList);
});

connection.end();