<?php
$connect = mysqli_connect('localhost', 'olegmowk_1', '1425pmrmsw', 'olegmowk_1');
if ($connect == false) {
    echo "Error connect";
}

$result = mysqli_query($connect, "
    SELECT categories.title, goods.name
    FROM categories
    INNER JOIN goods
    ON categories.id = goods.category
    ORDER BY categories.id;
");

while ( ($cat = mysqli_fetch_assoc($result)) ) {
    echo $cat['title'];
    echo " = ";
    echo $cat['name'];
}

?>