从多个表填充表单yii2 mysql

// 模型类
class MyForm extends \yii\base\Model
{
    public $field1;
    public $field2;
    // ... 其他字段

    public function rules()
    {
        return [
            [['field1', 'field2'], 'required'],
            // ... 其他验证规则
        ];
    }
}

// 控制器
class MyController extends \yii\web\Controller
{
    public function actionIndex()
    {
        $model = new MyForm();

        // 查询多个表的数据
        $query = (new \yii\db\Query())
            ->select(['table1.field1', 'table2.field2'])
            ->from('table1')
            ->join('INNER JOIN', 'table2', 'table1.id = table2.table1_id')
            ->where(['table1.id' => 1])
            ->one();

        // 填充表单字段
        $model->field1 = $query['field1'];
        $model->field2 = $query['field2'];

        return $this->render('index', [
            'model' => $model,
        ]);
    }
}

// 视图文件
<?= $form->field($model, 'field1')->textInput() ?>
<?= $form->field($model, 'field2')->textInput() ?>
<!-- 其他字段的表单组件 -->