Query structure in laravel 5 for getting nested array result

Question

I’m trying to make a dynamic resume. To show the skills I’ve created 3 tables as follows-

Skills - Contains all skill with expertise level
Groups - Contains category like front end, back end, database, programming etc
Skill_Groups - As one skill can be in multiple groups, I made this table. For example- PHP can be back end group also in programming group.

Skills

Groups

Skill_Groups

Now, I would like to display the groups and skills with nested list. Example-

For this, I need a multidimensional array. What should be the query in laravel to get the result on this way?

[This question may be duplicate one, but I didn’t found. If so, please let me know, I will merge/delete it.]

Any alternate solutions also appreciable, if have.

this is many to many relationship laravel.com/docs/5.3/eloquent-relationships#many-to-many — Sanzeeb Aryal
– Sanzeeb Aryal, Commented Oct 25, 2016 at 10:42

aleksejjj · Accepted Answer · 2016-10-25 10:20:32Z

2

In Model Group you can add relationship

public function skills()
{
    return $this->belongsToMany(Skill::class, 'skill_groups');
}

In Controller

$groups = Group::with('skills')->get();

In View

@foreach($groups as $group)
    {{ $group->name }}

    @foreach($group->skills as $skill)
        {{ $skill->name }}
    @endforeach
@endforeach

answered Oct 25, 2016 at 10:20

aleksejjj

1,83512 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1