How to sort a table by related fields?

Question

Yii

I welcome everyone!
I have two tables Host (fields id, ...request) and Request (fields id, host_id...) I need to get records from the Host table sorted by the field request. What is the correct way to write a request?

return Host::find()
                ->select('*, (SELECT count(id) FROM request WHERE request.host_id=id) as test_feild')
                ->orderBy('test_feild DESC')
                ->limit(10)
                ->all();