InvitationModel::getByInvitationID PHP Method

    public function getByInvitationID($InvitationID)
    {
        $DataSet = $this->SQL->from('Invitation i')->join('User su', 'i.InsertUserID = su.UserID')->join('User au', 'i.AcceptedUserID = au.UserID', 'left')->select('i.*')->select('au.UserID', '', 'AcceptedUserID')->select('au.Email', '', 'AcceptedEmail')->select('au.Name', '', 'AcceptedName')->select('su.UserID', '', 'SenderUserID')->select('su.Email', '', 'SenderEmail')->select('su.Name', '', 'SenderName')->where('i.InvitationID', $InvitationID)->get();
        return $DataSet->firstRow();
    }