sports_web/Application/Sports/Model/St_area_country.php

<?php
namespace App\Sports\Model;

use \System\Model;

/**
 * Class St_country
 * @package App\Sports\Model
 * 国家 地区 关系
 */
class St_area_country extends Model
{

    protected $table = 'st_area_country';

    //获取国家或地区 id
    public static function getID($opt = ''){
        $name = $opt;//国家或地区名称
        $ret = self::select('id','pid')
            ->where(['name'=>$name])
            ->first();

        if($ret->pid > 0){
            $data['area_id'] = $ret->pid;
            $data['country_id'] = $ret->id;
        }else{
            $data['area_id'] = $ret->id;
            $data['country_id'] = 0;
        }

        return $data;
    }

    /**
     * @param string $id 地区/国家 id
     * @param string $level 层级 1 地区 2国家
     * @return mixed
     * 根据条件获取地区/国家数据
     */
    public static function getName($id = '',$level=''){
        $where = [];
        //拼装查询条件
        if(!empty($id)){
            $where[] = ['id','=',$id];
        }
        if(!empty($level)){
            $where[] = ['level','=',$level];
        }
        $name = self::select('id','name')
            ->where($where)
            ->get()
            ->toArray();

        return $name;
    }
}