I'm trying to retrieve data from database to laravel blade view with join associate table.
in my case I have two tables called
courses. here some student can have many interesting courses. Therefore
courses_id stored as
json array in database as follows.
but I need to join the courses table to get the associate course name as follows.
["Hospitality","Business Management","Auto Mobile","Health Care"]
Below is my controller
$intresting_courses = DB::table('intresting_courses') ->join('courses','courses.id','=','intresting_courses.courses_id') ->where('intresting_courses.youth_id',$id) ->first();
How can I join the tables.