Hello everyone !
I'm have issue with select result of Query builder.
Four Tables
musics => [id, title, file, image, ............ ]
albums => [id, name, image, ....... ]
singers => [id,name]
music_singer
[id,music_id,singer_id]
return DB::table('musics')
->select(
'musics.id as id',
'musics.title as title',
'musics.file as file',
'musics.image as thumbnail',
'musics.duration as music_duration',
DB::Raw('IFNULL( `musics`.`size` , 0 ) as music_size'),
DB::Raw('IFNULL( `musics`.`view` , 0 ) as music_view'),
DB::Raw('IFNULL( `musics`.`download` , 0 ) as music_down'),
'singers.name as singer',
'albums.name as albums',
'albums.image as image_album',
'albums.image as image_thumb'
)
->join('singers', 'singers.id', '=', 'musics.singer_id')
->join('albums', 'albums.id', '=', 'musics.album_id')
->where('musics.active', true)
->whereIn('musics.status', ['renew','published'])
->orderByRaw("FIELD(musics.status , 'renew', 'published') ASC")
->paginate($number);
I want to get results
Fields => [id, title, singer, ablum]
Values =>
[ 01, title1, singer1-singer2, album1 ],
[ 01, title1, singer1-singer2, album1 ],
[ 02, title2, singer5-singer3, album1 ],
[ 03, title1, singer3-singer5, album1 ],
```
Thank you!