Sorting sql in strict order, how to set this query in Yii2?

Question

Yii

Hello.
----
Perhaps someone faced such a problem
SELECT * FROM `category` ORDER BY `priority`;
Outputs:

1
10
100
111
2
22
202
3
333
4

But in order. Well, there is such a tricky way to sort everything in strict accordance:
SELECT * FROM `category` ORDER BY (priority+0);
the result is:

1
2
3
4
10
22
100
111
202
333

Excellent )))
Question:
How to do this in Yii2? If for example the Category class

Answer 1

Who had a similar problem, just make a query like this in the database:

Category::find()->orderBy('LENGTH(priority), priority')->all()

Answer 2

www.yiiframework.com/doc-2.0/yii-db-expression.html