How to translate an element from a MySQL database into an associative PHP array. Code example

Get an element from the database:

$post = mysqli_query($db, "SELECT * FROM `posts` WHERE `id` = `1`");

translate it into an associative array:

$post = mysqli_fetch_assoc($post);