连接两个表的Django查询

from django.db import models

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

class Book(models.Model):
    title = models.CharField(max_length=100)
    author = models.ForeignKey(Author, on_delete=models.CASCADE)

books = Book.objects.select_related('author')
for book in books:
    print(book.title, book.author.name)

from django.db import models

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

class Post(models.Model):
    title = models.CharField(max varchar(100)
    tags = models.ManyToManyField(Tag)

posts = Post.objects.prefetch_related('tags')
for post in posts:
    print(post.title)
    for tag in post.tags.all():
        print(tag.name)