SELECT d.*, n.*
                  FROM fr_mnode AS n
                  LEFT JOIN fr_mdata AS d
                     ON d.mdata_node_id = n.mnode_id
                  WHERE n.mnode_left <= 324
                     AND n.mnode_right  >= 325
                     AND d.mdata_lang = "pl"
                 ORDER BY n.mnode_left ASC
Array
(
    [0] => Array
        (
            [0] => 89
            [mdata_id] => 89
            [1] => 89
            [mdata_node_id] => 89
            [2] => pl
            [mdata_lang] => pl
            [3] => Archiwum
            [mdata_name] => Archiwum
            [4] => 89
            [mnode_id] => 89
            [5] => 0
            [mnode_pid] => 0
            [6] => 205
            [mnode_left] => 205
            [7] => 502
            [mnode_right] => 502
            [8] => -1
            [mnode_access] => -1
            [9] => 0
            [mnode_visible] => 0
            [10] => 
            [mnode_redirect] => 
        )

    [1] => Array
        (
            [0] => 90
            [mdata_id] => 90
            [1] => 90
            [mdata_node_id] => 90
            [2] => pl
            [mdata_lang] => pl
            [3] => Foto
            [mdata_name] => Foto
            [4] => 90
            [mnode_id] => 90
            [5] => 89
            [mnode_pid] => 89
            [6] => 294
            [mnode_left] => 294
            [7] => 347
            [mnode_right] => 347
            [8] => -1
            [mnode_access] => -1
            [9] => 1
            [mnode_visible] => 1
            [10] => 
            [mnode_redirect] => 
        )

    [2] => Array
        (
            [0] => 91
            [mdata_id] => 91
            [1] => 91
            [mdata_node_id] => 91
            [2] => pl
            [mdata_lang] => pl
            [3] => Aparaty Cyfrowe
            [mdata_name] => Aparaty Cyfrowe
            [4] => 91
            [mnode_id] => 91
            [5] => 90
            [mnode_pid] => 90
            [6] => 319
            [mnode_left] => 319
            [7] => 344
            [mnode_right] => 344
            [8] => -1
            [mnode_access] => -1
            [9] => 1
            [mnode_visible] => 1
            [10] => 
            [mnode_redirect] => 
        )

    [3] => Array
        (
            [0] => 7
            [mdata_id] => 7
            [1] => 7
            [mdata_node_id] => 7
            [2] => pl
            [mdata_lang] => pl
            [3] => Panasonic
            [mdata_name] => Panasonic
            [4] => 7
            [mnode_id] => 7
            [5] => 91
            [mnode_pid] => 91
            [6] => 324
            [mnode_left] => 324
            [7] => 325
            [mnode_right] => 325
            [8] => -1
            [mnode_access] => -1
            [9] => 1
            [mnode_visible] => 1
            [10] => 
            [mnode_redirect] => 
        )

)
Array
(
    [0] => Array
        (
            [0] => 89
            [mdata_id] => 89
            [1] => 89
            [mdata_node_id] => 89
            [2] => pl
            [mdata_lang] => pl
            [3] => Archiwum
            [mdata_name] => Archiwum
            [4] => 89
            [mnode_id] => 89
            [5] => 0
            [mnode_pid] => 0
            [6] => 205
            [mnode_left] => 205
            [7] => 502
            [mnode_right] => 502
            [8] => -1
            [mnode_access] => -1
            [9] => 0
            [mnode_visible] => 0
            [10] => 
            [mnode_redirect] => 
        )

    [1] => Array
        (
            [0] => 90
            [mdata_id] => 90
            [1] => 90
            [mdata_node_id] => 90
            [2] => pl
            [mdata_lang] => pl
            [3] => Foto
            [mdata_name] => Foto
            [4] => 90
            [mnode_id] => 90
            [5] => 89
            [mnode_pid] => 89
            [6] => 294
            [mnode_left] => 294
            [7] => 347
            [mnode_right] => 347
            [8] => -1
            [mnode_access] => -1
            [9] => 1
            [mnode_visible] => 1
            [10] => 
            [mnode_redirect] => 
        )

    [2] => Array
        (
            [0] => 91
            [mdata_id] => 91
            [1] => 91
            [mdata_node_id] => 91
            [2] => pl
            [mdata_lang] => pl
            [3] => Aparaty Cyfrowe
            [mdata_name] => Aparaty Cyfrowe
            [4] => 91
            [mnode_id] => 91
            [5] => 90
            [mnode_pid] => 90
            [6] => 319
            [mnode_left] => 319
            [7] => 344
            [mnode_right] => 344
            [8] => -1
            [mnode_access] => -1
            [9] => 1
            [mnode_visible] => 1
            [10] => 
            [mnode_redirect] => 
        )

    [3] => Array
        (
            [0] => 7
            [mdata_id] => 7
            [1] => 7
            [mdata_node_id] => 7
            [2] => pl
            [mdata_lang] => pl
            [3] => Panasonic
            [mdata_name] => Panasonic
            [4] => 7
            [mnode_id] => 7
            [5] => 91
            [mnode_pid] => 91
            [6] => 324
            [mnode_left] => 324
            [7] => 325
            [mnode_right] => 325
            [8] => -1
            [mnode_access] => -1
            [9] => 1
            [mnode_visible] => 1
            [10] => 
            [mnode_redirect] => 
        )

)