how to get country, state, city name in database?? I want names to be displayed but instead id is displayed in database [closed]

cities table[countries table]states table](https://i.stack.imgur.com/ObyCi.png)

<?php

            $query = "SELECT * FROM `prac`";
            $query = "SELECT prac.id, countries.id, country, country_name FROM prac  JOIN countries ON prac.id = countries.id";
            
            
            // $query .= "SELECT * FROM prac JOIN countries ON prac.country = countries.country_name";
            // $query = "SELECT prac.id, countries.id FROM prac INNER JOIN countries ON prac.country = countries.id";
            // $query = "SELECT prac.id, countries.id FROM prac INNER JOIN countries ON prac.country = countries.id";
    
            $data = mysqli_query($con, $query);
        
                while($result=mysqli_fetch_assoc($data)){
                    
                ?>
    
               

instead of names ids are displayed in database