$query = DB::select('channel.id', 'channel.title', 'channel.url')->from('list')->join('channel')->on('list.channel_id', '=', 'channel.id')->execute(); print_r($query);