How to make 2 foreign keys for the same table in Doctrine?

Question

MySQL

Good afternoon I’ll say right away that I’m not
sure that I formed the title correctly, but I’ll try to reveal the problem here
Given:
Symfony + fosUser + doctrine + the rest is not important here
A site like a bug tracker with tickets
Tickets have such a table
id
title
text
author_id
target_user_id
That is, author_id - the one who created
the target_user_id - who is entrusted with the task
author_id - foreign key with the user table by id field - everything is clear
Then the question
is target_user_id - also foreign key with the user table by id
After accepting the changes - in the user table, the doctrine itself made the roles field of the text type, and in principle everything broke
neither the login of users works, nor any other action where the user table is at least somehow affected
. I understand that the reason is precisely in the second f.key - and the question is not so much about the code, but about the architecture and sql
1) I understand that there are two f.keys which are by and large the same in the table, they just differ in the name of the field - is it possible (most likely not) and how to do it right?
2) If more fields are added to the table that are somehow related to the user table, but with different users (for example: Author / validator / performer / tester) - what to do in such a situation?

Answer 1

1) It is possible to map 1...N properties of an entity onto the same entity in the above way. And that's okay.
2)

After accepting the changes - in the user table, the doctrine itself made the roles field of the text type

The doctrine itself will do nothing. See the mapping of the roles field. Either you or some bundle probably redefined it by specifying the text value of the field in the table.
3) Whatever the doctrine does "itself", use migrations and see what changes will be made to your database.