Eloquen ORM

1.多个字段求和

       $result = self::where('xxx','=',1)->get(array(DB::raw('SUM(xxx) AS a'),
                                                     DB::raw( 'SUM(xxxxx) AS b')))->toArray();

2.查询指定字段

方法a:

 $result = self::where('xxx','=',1)->get(array('id','username'))->toArray();

方法b:

$result = self::where('username',$username)->pluck('id');