Laravel水平分表及对应查询

余数一定小于除数,用10作为除数

可以把user表拆分成user0.......user9

根据id 可以确定用户存在哪个表中

查询所有数据

            for ($i = 0; $i < 10; $i++) {
                $queries->push(DB::table('user_operator_record' . $i)
                    ->where([
                        ['activity_id', $data['activity_id']],
                        ['activity_type', $data['activity_type']],
                    ])->whereIn('user_id', $ids));
            }
            $unionQuery = $queries->shift();
            $queries->each(function ($item, $key) use ($unionQuery) {
                $unionQuery->unionAll($item);
            });
            $lists = with(new \App\Models\UserOperatorRecord())->setTable('union_user_operator')
                ->from(DB::raw("({$unionQuery->toSql()}) as union_user_operator"))
                ->mergeBindings($unionQuery)
                ->orderBy('created_at', 'desc')
                ->paginate(30);
//一定是在查询后再加载关联模型
            $lists->load([
                'user' => function ($query) {
                    $query->select('id', 'name', 'avatar');
                }
            ]);