use Joomla\CMS\Factory;
use Joomla\Database\DatabaseDriver;
use Joomla\Database\ParameterType;
//连接数据库
$db = Factory::getContainer()->get(DatabaseDriver::class);
$this->db = $db;
$query = $this->db->getQuery(true);
//常规写法
q u e r y − > s e l e c t ( " ∗ " ) − > f r o m ( query->select("*")->from( query−>select("∗")−>from(this->db->quoteName(‘#__zmaxshop_province’, ‘t’))->where([$this->db->quoteName(‘t.id’) . "= " . p r o v i n c e i d ] ) − > o r d e r (