Take data from 2 tables at the same time Take data from 2 tables at the same time codeigniter codeigniter

Take data from 2 tables at the same time


select id, name, status, phone from people where status = 1UNION ALLselect id, name, status, phone from dog where status = 1