mysql查询从两个表中获取电影及其歌曲

I am using following code to fetch film and song from two films and songs table the issue is I can fetch only on song of that film using below query. but my requirement is to fetch all the songs of that film from song table which is having same filmid for its song.

$url=$_GET['url'];   
$sql = "SELECT * FROM films f    
inner join songs s on f.filmId = s.filmId    
WHERE f.url='$url'"; 

I also need to combine DATE_FORMAT(filmReleaseDate, '%d %M %Y' ) filmReleaseDate in above code

Table Structure

Film table

`filmId`,`filmName`,`url`,`director`,`actor`

Song table

`songId`,`songName`,`filmId`,`filmName`

$url=$_GET['url'];   
$sql = "SELECT * FROM films f    
left join songs s on f.filmId = s.filmId    
WHERE f.url='$url'";