Django ORM获取每个组的最新项目

from django.contrib.auth.models import Group
from django.db import models

class Project(models.Model):
    name = models.CharField(max_length=100)
    group = models.ForeignKey(Group, on_delete=models.CASCADE)
    created_at = models.DateTimeField(auto_now_add=True)

    def __str__(self):
        return self.name

from django.db.models import Max
from django.contrib.auth.models import Group
from .models import Project

def get_latest_projects_per_group(request):
    groups = Group.objects.all()
    latest_projects_per_group = []

    for group in groups:
        latest_project = Project.objects.filter(group=group).order_by('-created_at').first()
        latest_projects_per_group.append(latest_project)

    # 最新项目的列表 latest_projects_per_group 包含了每个组的最新项目

    return render(request, 'template.html', {'latest_projects_per_group': latest_projects_per_group})

{% for project in latest_projects_per_group %}
    <h3>{{ project.group }}</h3>
    <p>{{ project.name }}</p>
{% endfor %}