在Laravel Eloquent中查找重复项

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class User extends Model
{
    protected $table = 'users';
}

<?php

namespace App\Http\Controllers;

use App\User;
use Illuminate\Http\Request;

class UserController extends Controller
{
    public function findDuplicates()
    {
        $duplicates = User::select('email')
            ->groupBy('email')
            ->havingRaw('COUNT(*) > 1')
            ->get();

        return $duplicates;
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class SomeController extends Controller
{
    public function someMethod()
    {
        $controller = new UserController();
        $duplicates = $controller->findDuplicates();

        // 处理查询结果
    }
}