infantServiceApi/app/model/api/StoreProductReply.php

<?php
declare (strict_types = 1);

namespace app\model\api;

use think\Model;

/**
 * @mixin \think\Model
 */
class StoreProductReply extends Model
{
    protected $name = 'store_product_reply';

    /**
     * 获取评论列表
     * @param array $where
     * @param int $page
     * @param int $pageSize
     * @return array
     */
    public function getList($where = [], $page = 1, $pageSize = 20)
    {
        $query = $this->alias('r')
            ->field('r.*,u.nickname,u.avatar')
            ->leftJoin('user u', 'u.uid = r.uid')
            ->where($where);
        $totalCount = $query->count();
        $list = $query
            ->order('r.id', 'desc')
            ->page($page, $pageSize)
            ->select()
            ->toArray();
        return [
            'list' => $list,
            'totalCount' => $totalCount,
            'pageSize' => $pageSize,
            'page' => $page
        ];
    }
}