点击产品一级分类，同时获取该分类和属于该分类的子分类的产品

application\home\model\Product.php

/**
	 * 分页
	 */
	public function pageQuery(){
		$catId = (int)input('catId',0);
		$where[] = ['dataFlag','=',1];
		$where[] = ['isShow','=',1];
		if($catId != 0){
			//获取子集
			$ids = array();
			$ids[] = $catId;
			$ids = model('product_cat')->getChild($ids,$ids);
			$where[] = ['catId','in',$ids];
		}
		// if($catId != 0)$where[] = ['catId','=',$catId];
		// url里面出现2个catId,所以删除参数catId,http://maiqi.cc/home/Product/lists/catId/5.html?catId=5&page=1
		$param = request()->param();
		ZHTUnset($param,'catId'); 
		$rs = $this->where($where)
			->order('productId', 'desc')
			->paginate(12,false,['query' => $param]);
		return $rs;
	}

/**
	 * 迭代获取下级
	 */
	public function getChild($ids = array(),$pids = array()){
		$result = $this->where("dataFlag=1 and parentId in(".implode(',',$pids).")")->select();
		
		if(count($result)>0){
			$cids = array();
			foreach ($result as $key =>$v){
				$cids[] = $v['catId'];
			}
			$ids = array_merge($ids,$cids);
			return $this->getChild($ids,$cids);
		}else{
			return $ids;
		}
	}

/**
	 * 获取指定产品
	 */
	public function listProduct($type, $catId = 0, $num, $cache = 0)
	{
		$cacheData = cache('TAG_PRODUCT_' . $type . "_" . $catId . "_" . $num . "_" . $cache);
		if ($cacheData) return $cacheData;
		//检测是否有数据
		$where = [];
		$where[] = ['isShow', '=', 1];
		$where[] = ['dataFlag', '=', 1];
		if($catId != 0){
			//获取子集
			$ids = array();
			$ids[] = $catId;
			$ids = model('product_cat')->getChild($ids,$ids);
			$where[] = ['catId','in',$ids];
		}
		// if($catId > 0)$where[] = ['catId', '=', $catId];
		if($type != ''){
			$order = ''.$type.' desc,dataSort desc,productId desc';
		}else{
			$order = 'dataSort desc,productId desc';
		}
		$product = Db::name('product')
			->where($where)
			->field('productId,productTitle,productImg,productContent,create_time')
			->order($order)
			->limit($num)
			->select();
		// dump($product);
		cache('TAG_PRODUCT_' . $type . "_" . $catId . "_" . $num . "_" . $cache, $product, $cache);
		return $product;
	}