如何在django中获得按相关模型分组的最高值模型？

from django.db import models

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

class Product(models.Model):
    name = models.CharField(max_length=100)
    price = models.DecimalField(max_digits=10, decimal_places=2)
    category = models.ForeignKey(Category, on_delete=models.CASCADE)

from django.db.models import Max
from django.shortcuts import render
from .models import Category, Product

def get_highest_price_by_category(request):
    categories = Category.objects.annotate(highest_price=Max('product__price'))
    return render(request, 'your_template.html', {'categories': categories})

{% for category in categories %}
    <h2>{{ category.name }}</h2>
    {% if category.highest_price %}
        <p>Highest price: {{ category.highest_price }}</p>
        {% for product in category.product_set.all %}
            <p>{{ product.name }} - ${{ product.price }}</p>
        {% endfor %}
    {% else %}
        <p>No products found.</p>
    {% endif %}
{% endfor %}