import kml file and update a table in a mysql database using laravel

I have a KML file that is look like a XML, I need to upload this file and update a mysql database. The data is like this.

<Document>
    <name>GPSWaypoints-2020-10-16.kml</name>
    <Style id="inline">
        <LineStyle>
            <color>ff0000ff</color>
            <width>2</width>
        </LineStyle>
    </Style>
    <Style id="waypoint">
        <IconStyle>
            <Icon><href>http://maps.google.com/mapfiles/kml/pal4/icon61.png</href></Icon>
        </IconStyle>
    </Style>
    <Folder>
        <name>Waypoints</name>
        <open>1</open>
        <Placemark>
            <name>WPT 0011</name>
            <TimeStamp><when>2020-09-26T08:21:14Z</when></TimeStamp>
            <styleUrl>#waypoint</styleUrl>
            <Point><coordinates>-74.91270224,10.8081995</coordinates></Point>
            <ExtendedData>
                <Data name="accuracy">
                    <displayName>Accuracy</displayName>
                    <value>3.216</value>
                </Data>
                <Data name="provider">
                    <displayName>Provider</displayName>
                    <value>gps</value>
                </Data>
            </ExtendedData>
        </Placemark>
    </Folder>
</Document>
</kml>

I have this method to import the KML file

public function uploadKML(Request $request)
    {
            $file      = $request->file('kml');
            $filename  = $file->getClientOriginalName();
            $filename  = time() . "." . $request->kml->extension();
            $file->move(public_path('kml'), $filename);
            $path = $request->image->store('public');
            return response()->json(["message" => "Upload Success"]);      
    }

Now with the file after uploading, I need to read the KML and update the coordinates with the same ID of a table. The ID is in the name field of the KML. For example, in the field <name> WPT 0011 </name> The ID would be 0011, without the WPT.

The update method that I currently have is

public function update(Request $request, $id)
    {
        $data= Data::findOrFail($id);
        return $data->update($request->all());
    }

And this is my Data Model

<?php


class Data extends Model
{
    protected $fillable = ['id', 'coordinates' ....];
}

from import kml file and update a table in a mysql database using laravel