I made a program to change data from database tables, each table I named S1_code, S2_code, S3_code etc. in this code i use too much ifelse it makes it look bad

What should I do to make my code better

My if elseif code :

include 'connection.php';

$username = $_SESSION['username'];
$status = $_POST['status'];
$subjct_id = $_POST['subjct_id'];
$code = $_POST['code'];

$i = 1;

// s1
if ($subjct_id == 1) {
    mysqli_query(
        $conn,
        "UPDATE tb_lesson 
        SET s1 = '$status', s1_code = '$code' 
        WHERE username = '$username'"
    );

    // s2
} elseif ($subjct_id == 2) {
    mysqli_query(
        $conn,
        "UPDATE tb_lesson 
        SET s2 = '$status', s2_code = '$code' 
        WHERE username = '$username'"
    );

    // s3
} elseif ($subjct_id == 3) {
    mysqli_query(
        $conn,
        "UPDATE tb_lesson 
        SET s3 = '$status', s3_code = '$code' 
        WHERE username = '$username'"
    );

}
// and many more
(...)