How to display information of different table in twig symfony?

  html, inner-join, mysql, symfony, twig

I need to display a table, for example 4 columns, I have a Palmares entity with different information.

How to put data from another sql table in the same loop, other information is linked with palmares.categorie.code Here is a part of my template with html.twig

{% for palmares in palmares %}
 <td>other information from another table</td>
 <td>{{ |date("m/d/Y")}}</td>
{% endfor %}

Source: Symfony Questions