sql语句怎么不用原生的方式实现

可能是这样。。。

DB::table('test1')->select('test1.username', 'test2.num')->leftJoin('test2', function ($query) {
            /**@var \Illuminate\Database\Query\Builder $query  */
            $query->on('test.username', '=', 'test2.username');
            $query->where('status', '=', 1)->groupBy('test2.username');
        })

我还是喜欢这样的原生

TestOne::select([
            "username",
            DB::raw("(select count(*) from test2 where test2.username = test1.username and test2.status = 1)")
        ])->paginate(20);

这方法好多的啊... 我喜欢这么写 我不知道表结构是什么 关联关系自己去看着弄

    public static function getName() {
        return self::query()
            ->with([
                'test2' => function ($query) {
                    $query->select('username', DB::raw('count(*) AS num'))
                        ->where('status', 1)
                        ->groupBy('username');
                }
            ])
            ->get(['username']);
    }

    public function test2() {
        return $this->hasOne(Test2::class, 'username', 'username');
    }

一对多的表吗？test1表用户唯一？如果是的话感觉两个SQL结果一致

SELECT
    t1.username,
    COUNT(*) AS num
FROM
    test1 AS t1
    LEFT JOIN test2 AS t2 ON t1.username = t2.username