join 2 table orders wordpress plugin

// Get Product Count
$sql = “SELECT wcfm_affiliate_orders.*, ya.order_id,ya.order_status FROM {$wpdb->prefix}wcfm_affiliate_orders AS wcfm_affiliate_orders LEFT JOIN {$wpdb->prefix}wcfm_marketplace_orders AS ya ON ya.order_id = wcfm_affiliate_orders.order_id “;
$sql .= ” WHERE 1=1″;
$sql .= ” AND wcfm_affiliate_orders.affiliate_id = {$affiliate_id}

    ";
    if( $status ) $sql .= " AND  wcfm_affiliate_orders.commission_status="{$status}"";

    $sql .= " ORDER BY  wcfm_affiliate_orders.ID  DESC";
    $sql .= " LIMIT {$length}";
    $sql .= " OFFSET {$offset}";


    $wcfm_affiliate_orders_array = $wpdb->get_results( $sql );