two table match with same value in field mysql join php code example
Example: mysql join two tables
SELECT user_id, user_name
FROM users
UNION
SELECT organization_id, organization_name
FROM organizations
SELECT user_id, user_name
FROM users
UNION
SELECT organization_id, organization_name
FROM organizations