sql select

sqlSelect.php

<? php

public static function getAllIndicatorValuesOverview($userId = null) {             
        $surveys = self::getConnection()->query(
                'SELECT surveys.surveyId,surveys.year,user.organizationName
                FROM surveys
                LEFT JOIN user ON surveys.userId=user.userId'
                )->fetchAll();

        foreach($surveys as &$survey) {
            $indicators = self::getConnection()->query(
                'SELECT indicator.name,indicatorvalue.value
                FROM indicator
                LEFT JOIN indicatorvalue ON indicator.indicatorId=indicatorvalue.indicatorId
                WHERE indicatorvalue.surveyId=?', $survey['surveyId']
                )->fetchAll();
        
            foreach($indicators as $indicator) {
                $survey[$indicator['name']] = $indicator['value'];
            }
            
            $survey = (array) $survey;
        }      
                
        return $surveys;
    }