读取嵌套的json显示每个键值[来自mySQL]

import json

# 假设从MySQL数据库中获取的JSON数据
json_data = '{"name": "John", "age": 30, "address": {"city": "New York", "country": "USA"}}'

# 解析JSON数据
data = json.loads(json_data)

# 递归函数来处理嵌套的键值对
def process_json(data, prefix=''):
    for key, value in data.items():
        if isinstance(value, dict):
            # 处理嵌套的键值对
            process_json(value, prefix + key + '.')
        else:
            # 显示键值对
            print(prefix + key + ':', value)

# 调用递归函数来显示每个键值对
process_json(data)

name: John
age: 30
address.city: New York
address.country: USA