How to display data from a table using dropdown?

Question

Yii

There is such a structure of the subcategory table: id, category_id, name (that is, the ID, to which ID of the category the name of the subcategory belongs).
How can I get the list from the database like this?

i.e. a grouped list: category first, below it subcategories related to it.

Answer 1

Good evening.
You need to collect a multidimensional array, which you can pass to dropDownList().
It looks like this:

$form->field($model, 'status')->dropDownList(
        [
            'Активный' => ['Админ', 'Модератор', 'Пользователь'],
            'Отключён' => ['За нарушения', 'Самостоятельно']
        ],
        [
            'prompt' => 'Выбрать статус'
        ])