json分组多个数组相关数据

import json

# 假设有一个包含多个数组的JSON数据
json_data = '''
{
  "users": [
    {"id": 1, "name": "Alice"},
    {"id": 2, "name": "Bob"},
    {"id": 3, "name": "Charlie"}
  ],
  "orders": [
    {"id": 1, "user_id": 1, "product": "A"},
    {"id": 2, "user_id": 2, "product": "B"},
    {"id": 3, "user_id": 1, "product": "C"}
  ]
}
'''

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

# 分组处理
grouped_data = {}
for order in data['orders']:
    user_id = order['user_id']
    if user_id not in grouped_data:
        grouped_data[user_id] = []
    grouped_data[user_id].append(order)

# 输出结果
for user in data['users']:
    user_id = user['id']
    if user_id in grouped_data:
        print(f"User {user['name']} has orders:")
        for order in grouped_data[user_id]:
            print(f"  - Order {order['id']}: {order['product']}")