mysql> use test;
Database changed
mysql> create table parks(id int auto_increment primary key, name
varchar(32));
Query OK, 0 rows affected (0.12 sec)

mysql> create table activities(id int auto_increment primary key, park_id int, name varchar(32));
Query OK, 0 rows affected (0.02 sec)

mysql> insert into parks values(NULL, "pizzaland");
Query OK, 1 row affected (0.04 sec)

mysql> insert into activities values(NULL, 1, "pooping");
Query OK, 1 row affected (0.01 sec)

mysql> insert into activities values(NULL, 1, "programming");
Query OK, 1 row affected (0.01 sec)

mysql> select p.id, p.name, a.id, a.name from parks p join activities a on a.park_id = p.id;
+----+-----------+----+-------------+
| id | name      | id | name        |
+----+-----------+----+-------------+
|  1 | pizzaland |  1 | pooping     |
|  1 | pizzaland |  2 | programming |
+----+-----------+----+-------------+
2 rows in set (0.02 sec)