Untitled

select
       ms_student_parent_relation.student_parent_relation_id,
       ms_student_sibling.sibling_name,
       ms_student_sibling.sibling_nis,
       ms_student_sibling.student_id,
       ms_student_sibling.gender,
       ms_student_sibling.date_of_birth,
       ms_student_sibling.place_of_birth,
       ms_student_sibling.year_level_id,
       null as year_level_name
from ms_student_parent_relation
    join ms_student_sibling
        on ms_student_sibling.sibling_id = ms_student_parent_relation.sibling_id
where ms_student_sibling.deleted_at is null
    and ms_student_parent_relation.deleted_at is null
    and ms_student_parent_relation.user_uuid_parent = $1
union
select 
       ms_student_parent_relation.student_parent_relation_id,
       ms_student.student_name as sibling_name,
       ms_student.nis as sibling_nis,
       ms_student.student_id,
       ms_student.gender,
       ms_student.date_of_birth,
       ms_student.place_of_birth,
       ms_student.enroll_year_level_id as year_level_id,
       null as year_level_name
from ms_student_parent_relation
    join ms_student
        on ms_student.student_id = ms_student_parent_relation.student_id
where ms_student.deleted_at is null
    and ms_student_parent_relation.deleted_at is null
    and ms_student_parent_relation.user_uuid_parent = $1