$store1 = Store::select('cities.city_id','store_name','stores.store_id',\DB::raw('SUM(shijihuikuan_amount) as shijihuikuan_amounts'),\DB::raw('count(shijihuikuan_id) as shijihuikuan_count')) ->joinCity()->leftjoinStoreQianyue()->leftJoinShijihuikuan();