Doctrine 2.1 - bind an object to multiple tables

Question

I have the following database situation:

wp_users (user table generated by wordpress)
ID | user_login | ... 

wp_sp_user (extension to the wp_users table)
ID (FK) | surname | address | ... 

Now for several hours I tried to "merge" these two tables into one single object User, for example:

class User {
  var ID;
  var user_login;
  var surname;
  var address;
  ...
}

Is there a way to perform such a mapping without changing the table wp_user(which I do not want to do to explain the reasons)?

Answer 1

, "raison d'être". . User . wp_users wp_sp_user. .

:

http://docs.doctrine-project.org/en/latest/reference/inheritance-mapping.html#class-table-inheritance

Answer 2

. .

MySQL Doctrine. , .

- . , , .