Yii2 ActiveRecord get all records for last %interval%

php.php

<?php
$interval = 'DAY';
//$interval = 'WEEK';
//$interval = 'MONTH';

$brands = BrandExt::find()
                    ->where([
                        'between',
                        'brand.created_at',
                        new Expression(sprintf('date_sub(utc_timestamp, interval 1 %s)', $interval)),
                        new Expression('utc_timestamp')
                    ]);