使用多维数组将json转换为csv，其中子元素也具有父值

import csv

def json_to_csv(json_data):
    csv_data = []
    
    def flatten_json(data, parent_key=''):
        if isinstance(data, dict):
            for key, value in data.items():
                new_key = parent_key + '_' + key if parent_key else key
                flatten_json(value, new_key)
        elif isinstance(data, list):
            for i, item in enumerate(data):
                new_key = parent_key + '_' + str(i) if parent_key else str(i)
                flatten_json(item, new_key)
        else:
            csv_data.append([parent_key, data])
    
    flatten_json(json_data)
    
    with open('output.csv', 'w', newline='') as file:
        writer = csv.writer(file)
        writer.writerows(csv_data)

# 示例 JSON 数据
json_data = {
    "name": "John",
    "age": 30,
    "address": {
        "street": "123 Street",
        "city": "New York"
    },
    "hobbies": ["reading", "coding", "gaming"]
}

json_to_csv(json_data)