SELECT horario.Hora,horario.Inicio,horario.fin,horario.lunes,horario.martes,horario.miercoles
FROM horario
LEFT JOIN cargaacademica AS lu on lu.id_asignatura = horario.lunes
LEFT JOIN cargaacademica AS ma on ma.id_asignatura = horario.martes
LEFT JOIN cargaacademica AS mi on mi.id_asignatura = horario.miercoles
WHERE lu.cedula='383889' OR ma.cedula='383889' OR mi.cedula='383889'