Pymysql DictCursor返回列表而不是字典

import pymysql.cursors

# 连接数据库
connection = pymysql.connect(host='localhost',
                             user='user',
                             password='password',
                             db='database',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

import pymysql.cursors

# 连接数据库
connection = pymysql.connect(host='localhost',
                             user='user',
                             password='password',
                             db='database',
                             charset='utf8mb4')

# 创建游标
cursor = connection.cursor()

# 执行查询
sql = "SELECT * FROM table_name"
cursor.execute(sql)

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

# 转换为字典格式
dict_result = [dict(zip([column[0] for column in cursor.description], row)) for row in result]