Laravel по-русски

    public function getListing($page = null, $count = null) {
        $query = User::newQuery();

        $table = User::getTable();

        $query->select("{$table}.*", DB::raw('count(users.id) as images_count'));
        $query->leftJoin('images', 'images.user_id', '=', "{$table}.id");
        $query->havingRaw("images_count >= {$table}.image_limit");

        $queryCount = clone $query;
        $totalCount = $queryCount->distinct("{$table}.id")->count();

        $query->groupBy("{$table}.id");

        if (!is_null($page) && !is_null($count)) {
            $query->skip(($page - 1) * $count);
        };

        if (!is_null($count)) {
            $query->take($count);
        };

        $result = $query->get();

        return [
            $result,
            $totalCount,
        ];
    }