By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE users ( id INT, country varchar(255) );
INSERT INTO `users` (`id`, `country`) VALUES
(1, "German"), (2, "USA"), (3, "France");
SELECT * FROM users;
Records: 3 Duplicates: 0 Warnings: 0
| id | country |
|---|---|
| 1 | German |
| 2 | USA |
| 3 | France |
CREATE TABLE `influence-zone` ( id INT, name varchar(255), country varchar(255) );
INSERT INTO `influence-zone` (`id`, `name`, `country`) VALUES
(1, "zone", "German"), (2, "important", "USA"), (3, "zone89", "France"),
(4,"zone1", "ALL"), (5,"zone2", "ALL");
SELECT * FROM `influence-zone`;
Records: 5 Duplicates: 0 Warnings: 0
| id | name | country |
|---|---|---|
| 1 | zone | German |
| 2 | important | USA |
| 3 | zone89 | France |
| 4 | zone1 | ALL |
| 5 | zone2 | ALL |
SELECT * FROM `influence-zone` JOIN users ON `influence-zone`.country = users.country
| id | name | country | id | country |
|---|---|---|---|---|
| 1 | zone | German | 1 | German |
| 2 | important | USA | 2 | USA |
| 3 | zone89 | France | 3 | France |