how to create queries like this...

[eluser]tusukgigi[/eluser]
how to create queries in mysql like this

district table
----------------
id | district_name
1 ::: countries1
2 ::: countries2
3 ::: countries3
4 ::: countries4

city table
----------------
id | city_name | district_id
1 ::: jakarta ::: 1
2 ::: bandung ::: 1
3 ::: newyork ::: 2
4 ::: tokyo ::: 3
________________________________________
i want to create navigation like this

[+] Country1
-jakarta.
-bandung.

[+] Country2
-newyork

[+] Country3
-tokyo

[+] Country4
- [No list]

how to create the queries...
Im newbie

thanks very much for your answer