Mysql-MySql database, about data insertion.

There is a user table a with fields such as OID (primary key, auto-incrementing), username, gender, and creation time. Then there is another Table B, where the field is the primary key OID of the user table and the corresponding user identity RID. Identities are like super administrators, team leaders, leaders, and employees. Now we want to insert data to the user table. we just need to insert data to this user table. now we want to insert data to the user table by default. For example, the leader's RID is 1, the leader is 2, the user is 3, and the administrator is 0. The primary key OID of user table a corresponds to the RID of Table B. For example, if the first employee is 10000, the second employee is 10001, and the third employee is 10002, then Table B is 10001... mysql programming language database

There is a user table a with fields such as OID (primary key, auto-incrementing), username, gender, and creation time. Then there is another Table B, where the field is the primary key OID of the user table and the corresponding user identity RID. Identities are like super administrators, team leaders, leaders, and employees. Now we want to insert data to the user table. we just need to insert data to this user table. now we want to insert data to the user table by default.
For example, the leader's RID is 1, the leader is 2, the user is 3, and the administrator is 0.
The primary key OID of user table a corresponds to the RID of Table B. For example, the first employee is 10000, the second is 10001, and the third is 10002, in this case, Table B corresponds to 1, 10001, and 1, and 2, and 3. the problem is that table a can correspond to 2 (group leaders) by default when users are inserted to table a. how can this problem be solved. The programming language is JAVA. Ask me to solve the problem.