Untitled

mysql> select * from players;
+----+----------+-------+---------+------+
| id | owner_id | name  | surname | info |
+----+----------+-------+---------+------+
|  1 |        2 | Test  | Test 1  |      |
|  2 |        2 | Test  |  Test 2 |      |
|  3 |        2 |  Test |  Test 3 |      |
|  4 |        2 |  Test |  Test 4 |      |
+----+----------+-------+---------+------+
4 rows in set (0.00 sec)

mysql> select * from tourney_info;
+----+------------+-----------+
| id | tourney_id | player_id |
+----+------------+-----------+
|  1 |          1 |         1 |
|  2 |          1 |         2 |
|  3 |          1 |         3 |
|  4 |          1 |         4 |
|  5 |          2 |         1 |
+----+------------+-----------+
5 rows in set (0.00 sec)

mysql> select * from tourney;
+----+----------+---------+
| id | owner_id | name    |
+----+----------+---------+
|  1 |        2 | Tests 1 |
|  2 |        2 | Tests 2 |
+----+----------+---------+
2 rows in set (0.00 sec)