如何在Django中执行查询两个多对多字段？

from django.db import models

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

    def __str__(self):
        return self.name

class Book(models.Model):
    title = models.CharField(max_length=200)
    authors = models.ManyToManyField(Author, related_name='books')

    def __str__(self):
        return self.title

# 获取某个作者
author = Author.objects.get(name='John Doe')

# 获取该作者的所有书籍
books = author.books.all()

# 获取某本书
book = Book.objects.get(title='Some Book Title')

# 获取该书的所有作者
authors = book.authors.all()

from django.db.models import Count

# 假设我们有两个作者的ID
author_ids = [1, 2]

# 查询这两个作者共同写的书籍
books = Book.objects.filter(authors__in=author_ids).annotate(num_authors=Count('authors')).filter(num_authors=len(author_ids))

# 假设我们有两本书的ID
book_ids = [1, 2]

# 查询这两本书的共同作者
authors = Author.objects.filter(books__in=book_ids).annotate(num_books=Count('books')).filter(num_books=len(book_ids))

# 获取两个特定的作者
author1 = Author.objects.get(name='John Doe')
author2 = Author.objects.get(name='Jane Smith')

# 查询 author1 写的所有书籍，并且这些书籍中有 author2 参与
books = Book.objects.filter(authors=author1).filter(authors=author2)