Your close, but you have to join the two tables together to get the correct data.
your subscribe table should have a primary key column, the uploads tabel should have a foreign key column that is used to relate the upload top the subscriber. This foreign key column can be used to join the two tables together using an INNER JOIN:
SELECT uploads.*`, subscribe.*
FROM uploads
INNER JOIN subscribe on uploads.<primaryKey> = subscribe.<forignKey>
you will need to substitute the names of your primary and foreign key column in the example above.
See the following for more info on join queries:
sql_join.asp