atis //

User::find()
->orderBy(['id' => SORT_DESC])
->all();

class UsersRepository
{
    public function getLastUsers()
    {
        return new ActiveDataProvider([
            'query' => User::find(),
            'sort'  => ['defaultOrder' => ['id' => SORT_DESC]]
        ]);
    }
}

div.minus
div.center <- relative
      span.label
      span.value <- absolute OR vertical-align: bottom
      div.progress
          div.value
div.plus

SELECT * FROM accounts WHERE type IN (1, 2)
UNION ALL
SELECT * FROM accounts WHERE type IN (3, 4)

$sql = [];
$params = [];

$PDO; // Создаете PDO объект

for($i = 0, $max = 10; $i < $max; $i++) {

    $sql[] = "SELECT * FROM accounts WHERE type IN (?, ?)\r\n";

    $params[] = 0; // число 1
    $params[] = 1; // число 2
}

$query = implode("UNION ALL\r\n", $sql);

$sth = $PDO->prepare($query);

foreach($params as $key => $value) {

    $sth->bindValue($key, $value);
}

$sth->execute();
$sth->fetchAll(PDO::FETCH_ASSOC);