Why does User (sf3) always return only one role?

Question

symfony

I understand with sf3. The problem is that during (custom) authentication, the user selects only one role, the first one found in the database. I look at the profiler - the request for obtaining roles from the database is not limited by the number of lines.
User entity:

/**
 * @ORM\Entity
 * @ORM\Table(name="users")
 */
class User implements UserInterface, \Serializable
{
    // ...

    /**
     * @ORM\OneToMany(targetEntity="Role", mappedBy="user")
     */
    private $roles;

    public function __construct()
    {
        $this->roles = new ArrayCollection();
    }

    public function getRoles()
    {
        return $this->roles->toArray();
    }

    // ...
}

Role entity:

use Doctrine\ORM\Mapping as ORM;
use Symfony\Component\Security\Core\Role\Role as BaseRole;

/**
 * @ORM\Entity
 * @ORM\Table(name="users_role")
 */
class Role extends BaseRole
{
    /**
     * @ORM\Id
     * @ORM\ManyToOne(targetEntity="User", inversedBy="roles")
     */
    private $user;

    /**
     * @ORM\Column(type="string", length=30)
     */
    protected $role;

    // ...
}

What's wrong with mapping?

Answer 1

Offhand, I can assume that the problem is in the Role entity, you have the Id annotation in $user. This means that you must have a unique user_id for each entry. So I can’t even imagine how you managed to assign 2 roles for 1 user, if this database should not roll around for you.