How to display a "foreign key" value in an array in PHP?

Question

I have a current problem, I tried to search in the documentations and the answers already given in the same site, but none of the answers helped me.

In fact I have a database, and two tables.

-> gpscoordonnee

MariaDB [leguideduflaneur]> DESCRIBE gpscoordonnee;
+--------------+----------+------+-----+---------------------+----------------+
| Field        | Type     | Null | Key | Default             | Extra          |
+--------------+----------+------+-----+---------------------+----------------+
| id           | int(11)  | NO   | PRI | NULL                | auto_increment |
| Nom_Commerce | int(11)  | NO   | MUL | NULL                |                |
| date         | datetime | NO   |     | current_timestamp() |                |
+--------------+----------+------+-----+---------------------+----------------+
3 rows in set (0.017 sec)

-> marchantpart

MariaDB [leguideduflaneur]> DESCRIBE marchantpart;
+---------+--------------+------+-----+---------+----------------+
| Field   | Type         | Null | Key | Default | Extra          |
+---------+--------------+------+-----+---------+----------------+
| id      | int(11)      | NO   | PRI | NULL    | auto_increment |
| Nom     | varchar(200) | NO   |     | NULL    |                |
| Adresse | varchar(300) | NO   |     | NULL    |                |
| Tel     | int(11)      | NO   |     | NULL    |                |
| Email   | varchar(100) | NO   |     | NULL    |                |
+---------+--------------+------+-----+---------+----------------+
5 rows in set (0.016 sec)

In the gpscoordonnee table, the Nom_Commerce field is a foreign Keys of Name of the marchantpart table.

I want by displaying the Nom_Commerce that it displays the contents of Nom

AND NOT 1

I have already tried all these methods but nothing is displayed, not even an error :

SELECT n.Nom 
from gpscoordonnee us 
    LEFT JOIN marchantpart ON us.NID = n.Nom

OR

SELECT gpscoordonnee, marchantpart.Nom AS Nom_Commerce 
FROM gpscoordonnee 
    JOIN marchantpart ON marchantpart.Nom=gpscoordonnee.Nom_Commerce

I don't want this : Result that displays integers instead of names

But i want this : Result with names