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');