select
        a1_0.AGENCY_ID,
        a2_0.AGENCY_ID,
        a2_0.AGENCY_DETAIL,
        a1_0.AGENCY_TXT 
    from
        AGENCY_TABLE a1_0 
    left join
        AGENCY_DETAIL_TABLE a2_0 
            on a2_0.AGENCY_ID=a1_0.AGENCY_ID 
    where
        a1_0.AGENCY_ID=?

select
        u1_0.AGENCY_ID,
        u1_0.USER_ID,
        u1_0.USER_NAME 
    from
        USER_TABLE u1_0 
    where
        u1_0.AGENCY_ID=?

select
        g1_0.AGENCY_ID,
        g1_0.GROUP_ID,
        g1_0.GROUP_NAME 
    from
        GROUP_TABLE g1_0 
    where
        g1_0.AGENCY_ID=?

select
        u1_0.GROUP_ID,
        u1_1.USER_ID,
        a1_0.AGENCY_ID,
        a2_0.AGENCY_ID,
        a2_0.AGENCY_DETAIL,
        a1_0.AGENCY_TXT,
        u1_1.USER_NAME 
    from
        GROUP_USER u1_0 
    join
        USER_TABLE u1_1 
            on u1_1.USER_ID=u1_0.USER_ID 
    left join
        AGENCY_TABLE a1_0 
            on a1_0.AGENCY_ID=u1_1.AGENCY_ID 
    left join
        AGENCY_DETAIL_TABLE a2_0 
            on a2_0.AGENCY_ID=a1_0.AGENCY_ID 
    where
        u1_0.GROUP_ID in(select
            g1_0.GROUP_ID 
        from
            GROUP_TABLE g1_0 
        where
            g1_0.AGENCY_ID=?)