[jour] => Array
(
        [1] => on
        [2] => on
        [5] => on
        [7] => on
)

[heure1] => Array
(
        [8] => on
        [9] => on
        [10] => on
        [11] => on
        [12] => on
        [13] => on
        [18] => on
        [19] => on
        [22] => on
        [23] => on
)

[heure2] => Array
(
        [6] => on
        [8] => on
        [13] => on
        [15] => on
)

[heure5] => Array
(
        [10] => on
        [11] => on
        [12] => on
        [13] => on
        [14] => on
        [17] => on
)

[heure7] => Array
(
        [9] => on
        [10] => on
        [11] => on
        [12] => on
        [13] => on
        [14] => on
        [15] => on
        [16] => on
)

<?php

$postData = array(
    'heure1' => array(
        8  => 'on',
        9  => 'on',
        10 => 'on',
        11 => 'on',
        12 => 'on',
        13 => 'on',
        18 => 'on',
        19 => 'on',
        22 => 'on',
        23 => 'on'
    ),
    'heure2' => array(
        6  => 'on',
        8  => 'on',
        13 => 'on',
        15 => 'on'
    ),
    'heure5' => array(
        10 => 'on',
        11 => 'on',
        12 => 'on',
        13 => 'on',
        14 => 'on',
        17 => 'on'
    ),
    'heure7' => array(
        9  => 'on',
        10 => 'on',
        11 => 'on',
        12 => 'on',
        13 => 'on',
        14 => 'on',
        15 => 'on',
        16 => 'on'
    )
);

echo 'INSERT INTO t_table(mid, jour, debut, fin)
VALUES' . buildScheduleQueryValues($postData, 3 /* id du magasin */);

function groupSeq(array $tab)
{
    $result = array();
    
    reset($tab);
    $start = key($tab);
    $prev  = $start - 1;
    
    foreach($tab as $key => $val)
    {
        if($prev != $key - 1)
        {
            $result[] = array($start, $prev);
            $start = $key;
        }
        
        $prev = $key;
    }
    
    $result[] = array($start, $key);
    
    return $result;
}

function buildScheduleQueryValues(array $data, $mId)
{
    $query = array();

    foreach($data as $dayNum => $dayVal)
    {
        foreach(groupSeq($dayVal) as $period)
        {
            $query[] = '(' . (int)$mId . ', ' . (int)$dayNum[5] . ', ' 
                     . (int)$period[0] . ', ' . (int)$period[1] . ')';
        }
    }
    
    return implode(',' . PHP_EOL, $query);
}

INSERT INTO t_table(mid, jour, debut, fin)
VALUES(3, 1, 8, 13),
(3, 1, 18, 19),
(3, 1, 22, 23),
(3, 2, 6, 6),
(3, 2, 8, 8),
(3, 2, 13, 13),
(3, 2, 15, 15),
(3, 5, 10, 14),
(3, 5, 17, 17),
(3, 7, 9, 16)