Please someone should help me with the laravel relationship problem. Here is the problem description

https://stackoverflow.com/questions/72624835/select-other-data-in-another-table-using-eloquent

Your question has been answered from that link already

You can watch a short video on how many to many relationship works. Your question already has a detailed answer.

Karleb:
You can watch a short video on how many to many relationship works. Your question already has a detailed answer.

tollyboy5:
Your question has been answered from that link already

Thank you for reaching out.

You'll need 3 tables to form a link between many judges and many cases and then your witness table making it a total of 4 tables.

1. cases table: id, title
2. judges table: id, name
3. judge_case table: case_id, judge_id

4. witness table: id, case_id

below is the eloquent snippet for the Case class:

class Case extends Model {

public function judges()
{
return $this->belongsToMany(Judge::class);
}

public function witnesses()
{
return $this->hasMany(Witness::class);
}
}

this one below is the eloquent snippet for the judge class

class Judge extends Model {

public function cases()
{
return $this->belongsToMany(Case::class);
}
}

to pull up all judges with all their cases, all you need is

$judges = Judge::with('cases')->get();

to pull up all cases with their judges and witness, all you need is

$cases = Case::with(['judges', 'witnesess'])->get();