xinyi_admin/application/common/model/UserAddressModel.php

<?php
namespace app\common\model;
/**
 * 会员收货地址表
 * Class UserAddressModel
 * @package app\common\model
 */

class UserAddressModel extends BaseModel
{
    protected $table = 'user_address';

    /**
     * 获得用户的默认地址
     * @param $condition
     * @return array|false|\PDOStatement|string|\think\Model
     */
    public function getDefaultAddress($condition){
    return $this->alias('ua')
        ->field('ua.*,ca.name as province,cas.name as city,cass.name as area')
        ->join('city_area ca','ca.id=ua.province_id','LEFT')
        ->join('city_area cas','cas.id=ua.city_id','LEFT')
        ->join('city_area cass','cass.id=ua.area_id','LEFT')
        ->where($condition)
        ->find();
    }

    /**
     * 获得用户的地址
     * @param $condition
     * @return array|false|\PDOStatement|string|\think\Model
     */
    public function getUserAddress($condition){
        return $this->alias('ua')
            ->field('ua.*,ca.name as province,cas.name as city,cass.name as area')
            ->join('city_area ca','ca.id=ua.province_id','LEFT')
            ->join('city_area cas','cas.id=ua.city_id','LEFT')
            ->join('city_area cass','cass.id=ua.area_id','LEFT')
            ->where($condition)
            ->select();
    }
}