Create foreach with another foreach result

Question

I have a Course and this course has 1 or several Modules, and each Module has 1 or several disciplines. In my controller I did so:

$_modSelecionados = Modulo::select('id_modulo')->where('id_curso', $curso)->get();
$modSelecionados = [];
foreach ($_modSelecionados as $modulo) {
   $modSelecionados[] = $modulo->id_modulo;

   // Pega as Disciplinas do Módulo
   $_discSelecionadas = DisciplinaModulo::select('id_disciplina')->where('id_modulo', $modSelecionados)->get();
   $discSelecionadas = [];
       foreach ($_discSelecionadas as $disciplina) {
           $discSelecionadas[] = $disciplina->id_disciplina;
       }
}

I passed everything I need to View and rode like this:

@foreach($modulos as $modulo)
@if(in_array($modulo->id_modulo, $modSelecionados) ? 'selected' : '')
    <table>
       <thead>
          <tr>
              <th scope="col"><i class="fal fa-long-arrow-down"></i>{{ $modulo->nome }}</th>
              <th scope="col">Carga Horária</th>
          </tr>
          </thead>
          <tbody>
          @foreach($disciplinas as $disciplina)
             @if(in_array($disciplina->id_disciplina, $discSelecionadas) ? 'selected' : '')
             <tr>
                 <td style="width: 65%;">{{ $disciplina->nome }}</td>
                 <td>{{ $disciplina->carga_horaria }} horas</td></tr>
             @endif
          @endforeach
      </tbody>
      </table>
  @endif
@endforeach

What is happening is that it generates a table for each MODULE, but repeats the DISCIPLINES of module 1 for module 2. It does not seek the disciplines of Module 2. As in the image below:

How to solve this???

Answer 1

In its logic the problem is to pass the entire collection of disciplines without distinguishing what the relationship with each module.

Anyway, this is not the best way to work with Laravel and Eloquent.

Change the code in your templates to insert the relationships as described in the documentation. Here is an example:

class Modulo extends Model {
    // função com o relacionamento
    public function disciplinas() {
        // se o id chave estrangeira na tabela disciplina para modulo estiver
        // nos padrões descritos na documentação do Laravel
        return $this->hasMany(Disciplina::class);
    }
}

In the controller

$modulos = Modulo::where('id_curso', $curso)->get();

In view

@foreach($modulos as $modulo)
    <hr/>
    <p>{{ $modulo->nome }}</p>
    <p>Disciplinas</p>
    @foreach ($modulo->disciplinas as $disciplina)
        <p>{{ $disciplina->nome }}</p>
    @endforeach
@foreach

The example is simplified, but it is only to demonstrate the relationship between the models and how to recover using the "way" Eloquent.

In this way, each module returns its disciplines directly by the property described in its model class.