Add a remote XML file to my database

I want to add a remote xml file exemple.com/file.xml to mysql database

The XML file look like this:

<schedule>
<epg>
<channel name="Channel1">
<event live="0">
<category>League1</category>
<title>event1</title>
<startTime>2015-02-13T21:00:00</startTime>
<endTime>2015-02-13T22:45:00</endTime>
</event>
<event live="1">
<category>League2</category>
<title>event2</title>
<startTime>2015-02-13T21:00:00</startTime>
<endTime>2015-02-13T22:45:00</endTime>
</event>
</channel>
<channel name="Channel2">
<event live="0">
<category>League3</category>
<title>event3</title>
<startTime>2015-02-13T21:00:00</startTime>
<endTime>2015-02-13T22:45:00</endTime>
</event>
<event live="1">
<category>League4</category>
<title>event4</title>
<startTime>2015-02-13T21:00:00</startTime>
<endTime>2015-02-13T22:45:00</endTime>
</event>
</channel>
</epg>
</schedule>

My table structure : event ; category ; startTime ; endTime ; channel

I want to add just events with live="1"

Please help me :)