x = SELECT t.titulo as categoria, tb2.titulo as produto FROM categoria
LEFT JOIN tb2 ON tb2.id_cat = categoria.id
ORDER BY t.titulo ASC
<div class="wrapper">
<div class='cell'><h1>cat1</h1><span>prod1</span><span>prod2</span></div><div class='cell'><h1>cat2</h1><span>prod3</span></div><div class='cell'><h1>cat3</h1><span></span></div></div>
<style>
.wrapper{
display: table;
}
.cell {
display: table-cell;
border: 1px solid red;
padding: 10px;
text-align: center;
}
.cell span {
display: block;
}
</style>
Output for 8.3.5
Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
x = SELECT t.titulo as categoria, tb2.titulo as produto FROM categoria
LEFT JOIN tb2 ON tb2.id_cat = categoria.id
ORDER BY t.titulo ASC
<div class="wrapper">
<div class='cell'><h1>cat1</h1><span>prod1</span><span>prod2</span></div><div class='cell'><h1>cat2</h1><span>prod3</span></div><div class='cell'><h1>cat3</h1><span></span></div></div>
<style>
.wrapper{
display: table;
}
.cell {
display: table-cell;
border: 1px solid red;
padding: 10px;
text-align: center;
}
.cell span {
display: block;
}
</style>