根据Django中的一些条件，在一次查询中获得多个关联的模型

from django.db import models

class User(models.Model):
    name = models.CharField(max_length=100)

class Post(models.Model):
    title = models.CharField(max_length=100)
    content = models.TextField()
    user = models.ForeignKey(User, on_delete=models.CASCADE)

from django.db.models import Q

# 获取满足条件的用户和帖子
users = User.objects.filter(name='John')
posts = Post.objects.filter(Q(title__contains='django') & Q(user__in=users))

# 遍历结果
for post in posts:
    print(post.title)