问在yii2的where条件中使用字段作为递归函数

EN

function exp($date){
            $date = explode('/', $date);
            $Y = $date[0];
            $m = $date[1];
            $d = $date[2];

            return $Y;
        }

$promise = new ActiveDataProvider([
            'query' => Post::find()
            ->where('status = "show"')
            ->andWhere(['<=', exp('date1'), 'date2'])// date1is: 2018/02/03
            ->orderBy('id'),
            ]);