xinyi/application/common/model/ProductConfigModel.php

<?php
namespace app\common\model;
/**
 * 商品限购配置表
 * Class courseModel
 * @package app\common\model
 */

class ProductConfigModel extends BaseModel
{
    protected $table = 'product_config';


    /**
     *
     * @param array $condition
     * @return mixed
     */
    public function getProductConfigOne($condition=[]){
        $join=[
            ['product product','product.product_no=product_config.product_no','LEFT'],
            ['admin admin','admin.admin_id=product_config.admin_id','LEFT'],
        ];
        $this->alias('product_config')
            ->field('product_config.*,product.product_no,product.product_name,product.member_price,admin.admin_name')
            ->join($join);
        if($condition){
            $this->where($condition);
        }
        return $this->BaseModel($this->find());
    }
}