如何在django中合并两个表

# models.py
from django.db import models

class User(models.Model):
    username = models.CharField(max_length=100)
    email = models.EmailField()

class Profile(models.Model):
    user = models.OneToOneField(User, on_delete=models.CASCADE)
    bio = models.TextField()
    avatar = models.ImageField(upload_to='avatars/')

# views.py
from django.shortcuts import render
from .models import User, Profile

def merge_tables(request):
    # 获取所有用户及其详细信息
    users = User.objects.all()
    profiles = Profile.objects.all()

    # 合并两个表的数据
    merged_data = []
    for user in users:
        profile = profiles.filter(user=user).first()
        merged_data.append({
            'username': user.username,
            'email': user.email,
            'bio': profile.bio,
            'avatar': profile.avatar.url if profile.avatar else None
        })

    return render(request, 'merge_tables.html', {'data': merged_data})