kohana db查看执行的last_query(),直接print_r($query)即可

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

print_r($query);