How to check if a value exists in one of two database tables

You had not very good architecture for your application. Best way is in save user information in one table and use separated fields or linked table for save extra information.

In your case you case use UNION and check tables in one query.

And correct way is use SELECT COUNT(*) and check result instead SELECT *