// 基本形 DB::select()->from('hoge')->execute()->as_array(); // join DB::select()->from('hoge') ->join('moge','left')->on('hoge.moge_id','=','moge.id') ->execute()->as_array(); // order by DB::select()->from('hoge') ->order_by('hoge.pub_date','desc') ->execute()->as_array(); // group_by DB::select()->from('hoge')->group_by('hoge.moge_id') ->execute()->as_array(); // sumを取りたい DB::select(DB::expr('sum(