How to design the following query on Django ORM?

Question

Django

Good evening! I would like your help with the following:
There are three models:

class Modal(models.Model):
   semething

class Link(models.Model):

    active = models.BooleanField(default=True)
 
    next_modal = models.ForeignKey(Modal, blank=True, null=True)

    parent_modals = models.ManyToManyField(Modal, through='ModalItem', related_name="child_links")

class ModalItem(models.Model):
    modal = models.ForeignKey(Modal)
    ...
    link = models.ForeignKey(Link)

You need to get into the modals associated with a particular modal.
Linking one modal to another is done through the modalItem and LInk tables.
Modal oneToMany ModalItem
ModalItem ManyToOne Link
Link manyToOne Modal

hmm you need to use the minimum number of requests to get all the modals associated with the given one. With the help of banal recursion, I will get several thousand requests. Monkey patching also works well, but also for 500 requests. Therefore, we need your help! Thanks in advance

Answer 1

Django MPTT ?