mysql – How to use SELECT statement to get data from SQlite table using with dictionary values?

I have below dictionary values.
Example:

required = {'ID1': ('Name1', 'Name2'),
            'ID2': ('Name1', 'Name3'),
            'ID3': ('Name2')}

I want to print address of every matched names in above format.

Example Output:

('ID1', 'adress1' ,'adress2'),
('ID2', 'adress1' ,'adress3'),
('ID3', 'adress2')

Below is my example code.

import sqlite3


conn=sqlite3.connect('emp.db')
conn.execute("""CREATE TABLE IF NOT EXISTS branch
        (Emp_ID TEXT UNIQUE,
    Emp_Name    TEXT UNIQUE,
    Emp_Address TEXT
    )""")

conn.execute("""INSERT OR IGNORE INTO branch(Emp_ID, Emp_Name, Emp_Address) 
    VALUES('Emp1', 'Name1', 'adress1')""")

conn.execute("""INSERT OR IGNORE INTO branch(Emp_ID, Emp_Name, Emp_Address) 
    VALUES('Emp2', 'Name2', 'adress2')""")

conn.execute("""INSERT OR IGNORE INTO branch(Emp_ID, Emp_Name, Emp_Address) 
    VALUES('Emp3', 'Name3', 'adress3')""")

conn.execute("""INSERT OR IGNORE INTO branch(Emp_ID, Emp_Name, Emp_Address) 
    VALUES('Emp4', 'Name4', 'adress4')""")

conn.execute("""INSERT OR IGNORE INTO branch(Emp_ID, Emp_Name, Emp_Address) 
    VALUES('Emp5', 'Name5', 'adress5')""")

conn.commit()
conn.close()

For example ‘ID1’ (column) should not to be changed.
And ‘name1’ should take its address and ‘name2’should take its address and all matched names should take their addresses. Which statements are useful for my scenario. Is it possible? If possible how to to?