如何从db查询创建动态下拉列表？

from flask import Flask, render_template
import pymysql

app = Flask(__name__)

@app.route('/')
def index():
    # 连接数据库
    conn = pymysql.connect(host='localhost', user='username', password='password', db='database_name')
    cursor = conn.cursor()

    # 执行查询语句
    query = "SELECT id, name FROM options_table"
    cursor.execute(query)

    # 获取查询结果
    results = cursor.fetchall()

    # 解析结果集并创建下拉列表
    select_options = ""
    for row in results:
        option_value = row[0]
        option_text = row[1]
        select_options += f"<option value='{option_value}'>{option_text}</option>"

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

    # 渲染模板并传递下拉列表数据
    return render_template('index.html', options=select_options)

if __name__ == '__main__':
    app.run()