I need to get data from different table using sql query

$model is User table model.

$model->select(' user.*,country.countryname')->join('country','user.country=country.countryid','left')->findAll();