How to retrieve multiple values ​​from a row from a database?

Question

PHP

Good afternoon. There is a database with
country_name and city_name columns.
How to correctly form a query to display not only the name of the city, but also the country?

if(!empty($_POST["keyword"])) {
$query ="SELECT * FROM country WHERE city_name like '" . $_POST["keyword"] . "%' ORDER BY city_name LIMIT 0,5";
$result = $db_handle->runQuery($query);
if(!empty($result)) { ?>
    <ul id="country-list">
    <?php
    foreach($result as $country) {
    ?>
        <li onClick="selectCountry('<?php echo $country["city_name"]; ?>');"><?php echo $country["city_name"]; ?></li>
    <?php } ?>
    </ul>
<?php }
}

Answer 1

SELECT city_name, city_country FROM country WHERE city_name like ........
.........');"><?php echo $country["city_country"]; ?><?php echo $ country["city_name"]; ?>

Answer 2

Why * if you only need two columns?

select CONCAT(country_name, ' ', city_name) as Country_City
from country
where city_name like '%%';

As an option:

select country_name + ' ' + city_name AS Country_City
from country
where city_name like '%%';