MySQL query to return users and categories

[dquelhas]

Hello,

i was looking for the link between the users table, categories table and albuns table without success.
I want to make a query to return the usernames and their categories. Something like:

array(
    user1 => 10003,
    user2 => 10007,
    etc.
)

Can someone help me?

Thanks in advance,

Dinis

[Nibbler]

The category is numbered as 10000 + user_id.

[dquelhas]

Thanks mate,

it's solved