$rows = (new yiidbQuery())
	->select(["dyn_id", "dyn_name"])
	->from("zs_dynasty")
	->where(["between","dyn_id", 1,30])
	->limit(10)
	->all();
print_r($rows);

use yiidbQuery;
$query = (new Query())
    ->from("user")
    ->orderBy("id");

$query->select("*")->
select("dyn_id as id, dynasty.dyn_name")->
$query->select(["dyn_id as id", "CONCAT(dyn_name,"a")"])->
$query->select("user_id")->distinct()->