How to make a query to the database in Yii2?

Question

MySQL

Hello. you need to make the following query using Yii2

SELECT * FROM table WHERE (id= '$id') AND (blocked = 1 or blocked = null )

I got the code like this:

$model2 = Table::find()->where(['id' => $model->id])->andWhere(['blocked' => null])->orWhere(['blocked' => '1'])->all();

But it doesn't work correctly. Please tell me how to make it right.
Thanks in advance to all who respond.

Answer 1

->where(['and',['id'=>$id],['or','blocked=1','blocked=null']])

Answer 2

where('id=:id and (blocked=1 or blocked is null)')->bind(':id', $id')