将mysql表数据转换为JSON嵌套格式

SELECT * FROM users;

import json
import pymysql

# 连接MySQL数据库
conn = pymysql.connect(host='localhost', user='username', password='password', db='database_name')
cursor = conn.cursor()

# 执行查询语句
cursor.execute("SELECT * FROM users")

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

# 将查询结果转换为JSON格式
json_data = []
for row in results:
    user = {'id': row[0], 'name': row[1], 'age': row[2]}
    json_data.append(user)

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

# 将JSON数据打印输出
print(json.dumps(json_data))

{
  "users": [
    {"id": 1, "name": "John", "age": 25},
    {"id": 2, "name": "Jane", "age": 30},
    ...
  ]
}