转换JSON，在每个(属性？对象？)带多行的to CSV返回一个字符串中的所有值

import json
import csv

def json_to_csv(json_str):
    # 解析JSON字符串为Python对象
    data = json.loads(json_str)

    # 提取所有属性值
    values = []
    extract_values(data, values)

    # 将属性值写入CSV字符串
    csv_str = ''
    writer = csv.writer(csv_str)
    writer.writerow(values)

    return csv_str

def extract_values(data, values):
    if isinstance(data, dict):
        for key, value in data.items():
            if isinstance(value, (dict, list)):
                extract_values(value, values)
            else:
                values.append(value)
    elif isinstance(data, list):
        for item in data:
            extract_values(item, values)

# 示例JSON字符串
json_str = '''
{
    "name": "John",
    "age": 30,
    "address": {
        "street": "123 Main St",
        "city": "New York",
        "state": "NY"
    },
    "hobbies": ["reading", "music", "sports"]
}
'''

# 转换JSON为CSV字符串
csv_str = json_to_csv(json_str)
print(csv_str)

John,30,123 Main St,New York,NY,reading,music,sports