support for multiple joining tables

(Sorry for being so slow in replying!)

The easiest way is probably to create a view:

CREATE OR REPLACE VIEW user_information AS
SELECT u.user_login,m.meta_value
FROM wp_user u JOIN wp_user_meta m ON m.user_id=u.user_id