actually you can use MySql views for this purpose and yii doesn’t differ views from tables.
you can generate models by gii but generating CRUD need the table to have a primary key so you can create your model by gii and do the rest (controller and views) by yourself or otherwise you can simply add a primary key in your model and then use gii to generate CRUD for you then remove parts that you don’t need
add this to your view Model and then try gii CRUD generator again
public function primaryKey()
you also need to change this part to make it work: