search for column name in laravel to get rows

i have two table(jobs,skills) skills jobs

i want to search by laravel for jobs by skill. when i write html -> 1-(search for column name) 2-(get rows where that column equal 1 ) 3-(get jobs where job_id(table job) = job_id(table skill)

that my code

           $search_name = $request->input('search');

          $skillscolumns =  DB::getSchemaBuilder()->getColumnListing('skills');



//1
$query = Skill::select('*');
foreach($skillscolumns as $column)
{
   $query->where($column, '=', $search_name);
}
$searchedColumn = $query->get();

//2
foreach ($searchedColumn  as  $value) {
     $skillRows = collect($value)->filter(function ($value){ return $value === 1;})->get();
}


//3
foreach ( $skillRows  as  $value) {
$wantedJobs=    Job::where('job_id',$value->job_id)->get();
}

via Chebli Mohamed