How Can I Build Merge and Build Group Query on Laravel?

Question

Now I am using this Query To Display Below Result Query:

 $data['faculty'] = Faculty::select('faculties.id', 'faculties.faculty', 'faculties.slug', 'faculties.status','s.semester','fs.faculty_id')
->join('faculty_semester as fs', 'faculties.id', '=', 'fs.faculty_id')
->join('semesters as s', 's.id', '=', 'fs.semester_id')
->orderBy('faculties.faculty', 'asc')
->get();

Display Result

1     BBA      FIRST SEM
2     BBA      SECOND SEM   
3     BBA      FOURTH SEM
4     BBA      THIRD SEM
5     BBS      SECOND YEAR
6     BBS      FIRST YEAR

But I want To Display on Group. How Can I Build Group Query on Laravel To Display Below Result

1     BBA      FIRST SEM, 
               SECOND SEM
               THIRD SEM
               FOURTH SEM
2     BBS      FIRST YEAR
               SECOND YEAR

Answer 1

I would recommend using eager loading, declaring relationships in models

https://laravel.com/docs/5.5/eloquent-relationships#eager-loading, so you can avoid using joins..

Did you try this?

$data['faculty'] = Faculty::select('faculties.id', 'faculties.faculty', 'faculties.slug', 'faculties.status','s.semester','fs.faculty_id')
->join('faculty_semester as fs', 'faculties.id', '=', 'fs.faculty_id')
->join('semesters as s', 's.id', '=', 'fs.semester_id')
->groupBy('faculties.faculty')
->get();