Selecting specific column value with condition

Question

I want to get a specific column from User table in yii2 using active record below is my code

$model = User::findOne(['id' => 1]);

this will return all the column from the table with user id equal 1, but suppose i just want to get only username and email from this column how do i write the query with active record, i tried the below code but it wont work..`

$model = User::find('username','email')->where('id'=1)

Answer 1

$model = User::find()
       ->select(['column1', 'column2'])
       ->where(['id' => $id])
       ->one();