我使用OrderingFilter，我有比萨饼模型连接到比萨饼模型通过多对多字段，当我订购的desc或asc我得到的不是预期的结果，如何可以得到queryset订购的价格或价格的第一个数字的总和
models.py

class Categorie(models.Model):
    name = models.CharField(max_length=60, default=[0])

    def __str__(self) -> str:
        return self.name

class PizzaPrice(models.Model):
    price = models.DecimalField(max_digits=8, decimal_places=2)

    def __str__(self) -> str:
        return str(self.price)
    
    class Meta:
        ordering = ['price']

class PizzaSize(models.Model):
    size = models.IntegerField()

    class Meta:
        ordering = ['size']

    def __str__(self) -> str:
        return str(self.size)

class Pizza(models.Model):
    name = models.CharField(max_length=60)
    imageUrl = models.CharField(max_length=150)
    category = models.ForeignKey(Categorie, default=1, on_delete=models.CASCADE)
    rating = models.IntegerField(choices=PIZZA_RATING, default=1)
    sizes = models.ManyToManyField(PizzaSize, blank=True, default=[0])
    prices = models.ManyToManyField(PizzaPrice, blank=True, default=[0])

    def __str__(self) -> str:
        return self.name

字符串
serializer.py

class PizzaSerializer(serializers.ModelSerializer):
    category = serializers.CharField(source='category.name')
    sizes = serializers.SlugRelatedField(many=True, read_only=True, slug_field='size')
    prices = serializers.SlugRelatedField(many=True, read_only=True, slug_field='price')

    class Meta:
        model = Pizza
        fields = '__all__'

型
views.py

class PizzasList(generics.ListAPIView):
    queryset = Pizza.objects.all()
    serializer_class = PizzaSerializer
    pagination_class = PageNumberPagination
    filter_backends = [DjangoFilterBackend, OrderingFilter]

    filterset_fields = ['category']
    ordering_fields = ['rating', 'name', 'prices']

型
example of result: ordering by prices
我尝试了很多选择，但没有帮助
我开始学习Django不是很久，我知道的不多，我希望你能帮助这个问题，谢谢你的关注
want to get queryset order by total sum of prices or first number in prices的