error on registering a user

[emadubuko]

@MichaelBuen,
greetings.
I got this error on trying to register a user

select role0_.name as col_0_0_ from identity.user_role roles1_ inner join identity.role role0_ on roles1_.role_fk=role0_.id where roles1_.user_fk = :p0

on the database i found out that there is no data saved on the user_role table. i had already inserted data in role table and i assume it will be referenced by default.

how and where do i assign role object to a newly created user ?