如何在获取相同表但条件不同的情况下同时使用2个while循环

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='database_name')
cursor = conn.cursor()

# 查询语句1
query1 = "SELECT * FROM table_name WHERE condition1"

# 查询语句2
query2 = "SELECT * FROM table_name WHERE condition2"

# 执行查询语句1
cursor.execute(query1)
result1 = cursor.fetchall()

# 执行查询语句2
cursor.execute(query2)
result2 = cursor.fetchall()

# 处理查询结果1
while result1:
    # 从结果集中获取数据
    data = result1.fetchone()

    # 处理数据
    # ...

    # 获取下一行数据
    result1 = cursor.fetchone()

# 处理查询结果2
while result2:
    # 从结果集中获取数据
    data = result2.fetchone()

    # 处理数据
    # ...

    # 获取下一行数据
    result2 = cursor.fetchone()

# 关闭数据库连接
cursor.close()
conn.close()