Correct way of implementing if else loop or else if and can i write function inside a loop

function toltalRetailerComm($userId) {
    //print_r ($shoppeId);
    $sql = "SELECT shoppe_id FROM atm_super_shoppe WHERE user_id='$userId'";
    $query = $this->db->query($sql);
    if ($query->num_rows() > 0) {
        $result = $query->row();
        $shoppeId = $result->shoppe_id;

        $sql = "SELECT COALESCE(sum(commission),0) as commission FROM atm_shoppe_commission WHERE shoppe_id ='$shoppeId'";
        $query = $this->db->query($sql);
        print_r($shoppeId);
        if ($query->num_rows > 0) {
            $result = $query->row();
            $commission = $result->commission;
            return $commission;
        } else {
function toltalRetailerComm($userId) {
    //pr