如何在django中过滤两个外键

from django.db import models

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

class ModelB(models.Model):
    model_a = models.ForeignKey(ModelA, on_delete=models.CASCADE)
    status = models.CharField(max_length=100)

class ModelC(models.Model):
    model_b = models.ForeignKey(ModelB, on_delete=models.CASCADE)
    date = models.DateField()

from datetime import date

# 获取ModelC中ModelA的name为"example"并且ModelB的status为"active"的结果
result = ModelC.objects.filter(model_b__model_a__name="example", model_b__status="active")

# 获取ModelC中ModelA的name为"example"并且ModelB的status为"active"且date大于今天的结果
result = ModelC.objects.filter(model_b__model_a__name="example", model_b__status="active", date__gt=date.today())