symfony 5 get data of many to many relation

Question

how i get user_id of table : user_evento ?

i need compare who user join on table : evento,

enter image description here

controller

    public function evento_detalle(Evento $evento){
        if(!$evento){
          return $this->redirectToRout('ver_eventos');
        } 
        $salas = $this->getDoctrine()->getRepository(Sala::class)->findBy([],['id' => 'desc']);
        $users =  $this->getDoctrine()->getRepository(User::class) ->findBy([],['id' => 'ASC']);

        return $this->render('evento/ver-evento.html.twig',[
            'eventos' =>$evento,
            'users' =>$users,
            'salas' =>$salas
        ]);

    }

twig

{% for user in users %}
    {% if user.id == eventos.getUsers.evento %}
    <tr>
        <td>

        {{ user.nombre }} 

        </td>
        <td> </td>
        <td> </td>
        <td> </td>
        <td>  </td>

    </tr>
    {%endif%}
{% endfor %}    

question from:https://stackoverflow.com/questions/65901322/symfony-5-get-data-of-many-to-many-relation

Answer 1

If you are trying to list Users associated with a particular Evento you should find them all in the collection returned by the Evento::getUsers() method, provided you have followed best practices for Symfony.

{% for user in eventos.getUsers %}
  ...
  {{ user.nombre }} 
  ...
{% endfor %}