在codeigniter中如何使用where子句进行连接

so i have two tables, and i want to get all the rows from table 1 that meet the where clause conditions, and then join them with table two based on the join conditions. so i have two tables, and i want to get all the