[Solved] mysql Search data from multiple table

SELECT * from user, category 
WHERE user.id=[text field]  
or category.user_id=[text field]  
or category.cat_id=[text field]