Symfony ChoiceType按2个数据库表分组

use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
use Symfony\Component\Form\AbstractType;
use Symfony\Component\Form\FormBuilderInterface;

class YourFormType extends AbstractType
{
    public function buildForm(FormBuilderInterface $builder, array $options)
    {
        $builder
            ->add('yourField', ChoiceType::class, [
                'choices' => $this->getChoices(),
                'group_by' => function($choice, $key, $value) {
                    // 根据需要的字段进行分组
                    return $choice->getGroup();
                },
            ]);
    }

    private function getChoices()
    {
        // 从数据库中获取数据并返回选项数组
        // 可以使用Doctrine ORM或其他数据库操作工具
        // 示例代码：
        $choices = [];

        $group1Entities = $this->getDoctrine()->getRepository(Group1Entity::class)->findAll();
        foreach ($group1Entities as $entity) {
            $choices['Group 1'][$entity->getId()] = $entity->getName();
        }

        $group2Entities = $this->getDoctrine()->getRepository(Group2Entity::class)->findAll();
        foreach ($group2Entities as $entity) {
            $choices['Group 2'][$entity->getId()] = $entity->getName();
        }

        return $choices;
    }
}