Answers for "how to get specific column value by using vlaue function in laravel"

laravel get single column value

$items = DB::table('items')
             ->select('id', 'ref_code', 'name', 'price')
             ->where('ref_code','=', $request->ref_code)
             ->first();

get specific columns using with() function in laravel eloquent

Post::with('user:id,username')->get();