Django prefetch_related over 3 models (one "relationship Model"

I'm trying to aggregate and Output Data from my Models to my HTML Page

Models.py

from django.db import models
from django.contrib import admin
class ClientDB(models.Model):
    Hostname= models.CharField(max_length=50,primary_key=True)
    User= models.CharField(max_length=100)
    
class VULDB(models.Model):
    VID=models.IntegerField(primary_key=True)
    CVELIST=models.CharField(max_length=50)
    CVSScore=models.FloatField(max_length=5)
    Serverity=models.CharField(max_length=25)
    Title=models.CharField(max_length=1000)
    Summary=models.CharField(max_length=1000)
class ClientVULDB(models.Model):
    
    Hostname= models.ForeignKey(ClientDB, on_delete=models.CASCADE)
    VID=models.ForeignKey(VULDB, on_delete=models.CASCADE)
    Path=models.CharField(max_length=1000)
    isActive=models.BooleanField(default=True)
    class Meta:
        constraints = [
            models.UniqueConstraint(
               fields=['Hostname', 'VID'], name='unique_migration_host_combination' # legt 
            )
        ]

I would like to create a view that Output and aggregate Data in the Model to my HTML Template. I need help how I can aggregate (and put it in an Queryset?) the data like in the Screenshot

I've got two Querysets which Query the Models:

q1=VULDB.objects.filter().values_list('Title','clientvuldb__Hostname')
    q2=ClientDB.objects.filter().values_list('Hostname', 'Benutzer', 'clientvuldb__VID')

The Output is as follows:

<QuerySet [('Test-VUL', 'Host2'),
('Test-VUL2', 'Host2'),
('Test-VUL3', 'Host1'),
('Test-Vul4', 'Host2')]>

<QuerySet [ ('Host1', 'User1', 1),
('Host2', 'User2', 1)]

I would like to render

Host1, Test-VUL3

Host2, Test-VUL, Test-VUL2, Test-VUL3

Don't use .values(..) or .values_list(..), it will erode the model layer.

work with:

<pre><code>from django.db.models import Prefetch

qs = VULDB.objects.prefetch_related(
<b>Prefetch(</b>'clientvuldb_set', ClientVULDB.objects.select_related('VID')<b>)</b>
)</code></pre>

in the template, render with:

<pre><code>&lt;ul&gt;
{% for item in qs %}
&lt;li&gt;{{ qs.Hostname }}</li>
&lt;ul&gt;
{% for subitem in <b>item.clientvuldb_set.all</b> %}
&lt;li&gt;{{ subitem.VID.Title }}&lt;/li&gt;
{% endfor %}
&lt;/ul&gt;
{% endfor %}
&lt;/ul&gt;</code></pre>

> Note: normally the name of the fields in a Django model are written in snake_case, not PascalCase, so it should be: title instead of <s>Title</s>.

> Note: Models normally have no Db suffix. A model is not a table, it is stored in a relational database as a table, but even then it has extra logic like validators, managers, etc.