How to use orderBy() when using Join in yii2?

Question

MySQL

You need to sort the records by the attached table. How can I do that? The following construct does not work...

$entries = EntryItems::find()->where(['acc_id'=>$model->id,'entry.status'=>Entry::STATUS_ACTIVE]) ->innerJoin('entry','entry.id=entry_items.id')->orderBy('entry.date_paid')->with('entry')->all();