如何将mysql表中的数据添加到已格式化的html页面

import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')
cursor = cnx.cursor()

# 查询MySQL表数据
query = "SELECT * FROM your_table"
cursor.execute(query)
result = cursor.fetchall()

# 将查询结果转换为HTML格式
html = "<table>"
html += "<tr><th>Column 1</th><th>Column 2</th></tr>"
for row in result:
    html += "<tr>"
    html += "<td>{}</td>".format(row[0])
    html += "<td>{}</td>".format(row[1])
    html += "</tr>"
html += "</table>"

# 生成HTML页面
with open("output.html", "w") as file:
    file.write(html)

# 关闭数据库连接
cursor.close()
cnx.close()